Hi Robert,
Thanks for your answer but I am not that up there with creating formula
with that many variables.... But you have given me an idea that I will
investigate further. IF...THEN. Just need to tackle length's and positions
Janelle
"robert111" wrote:
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