topic-34960

Posts: 175

Joined: Tue Nov 10, 2009 10:56 AM

Number to letter
Posted: Wed Dec 06, 2017 02:58 PM

Hi
nRow = 6
do while nRow <= 31
oSheet:Cells( nRow, 13 ):FORMULA := "=" + G7-F7"
nRow = nRow + 1
enddo

  How to change number to letter, so that it besomes:
  G7 - F7
  G8 - F8
  G9 - F9

Regards
ACWoo
Using FWH1510+bcc582

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Number to letter
Posted: Wed Dec 06, 2017 03:04 PM

CHR( nCol + 64 ) + LTrim( Str( nRow ) )
Works for values of nCol from 1 to 26

Regards

G. N. Rao.

Hyderabad, India

Posts: 175

Joined: Tue Nov 10, 2009 10:56 AM

Re: Number to letter
Posted: Thu Dec 07, 2017 01:58 AM

Thanks Mr Rao

It works.

Regards

ACWoo

FiveTech Support Forums