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
FiveTech Software tech support forums
www.FiveTechSoft.com
Number to letter
3 posts • Page 1 of 1
Number to letter
by acwoo1 » Wed Dec 06, 2017 2:58 pm
- acwoo1
- Posts: 173
- Joined: Tue Nov 10, 2009 10:56 am
Re: Number to letter
by nageswaragunupudi » Wed Dec 06, 2017 3:04 pm
CHR( nCol + 64 ) + LTrim( Str( nRow ) )
Works for values of nCol from 1 to 26
Works for values of nCol from 1 to 26
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
-
nageswaragunupudi - Posts: 10663
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
3 posts • Page 1 of 1
Return to FiveWin for Harbour/xHarbour
Who is online
Users browsing this forum: Google [Bot] and 45 guests