make a lookup table as below
1 one
2 two
3 three
etc etc
assume number is 1234.56 and is in cell A1
B1= text(A1,"0.00") ie it still LOOKS like 1234.56
C1 =left(B1) ie 1
D1 = mid(A1,2,1) ie 2
and so on
You may need to check the length of the text string =len(B1)
and where the decimal is =search(B1,".")
to make it universal
You can either have all these formulas in separate columns or combine
them for tidyness.
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread:
http://www.excelforum.com/showthread...hreadid=529517