I want to parce a number like "123.45" so that the 1, 2, 3, 4 and 5 are in separate cells.
J JimR Nov 22, 2006 #1 I want to parce a number like "123.45" so that the 1, 2, 3, 4 and 5 are in separate cells.
R Roger Govier Nov 22, 2006 #2 Hi Jim Try entering in B1 =MID($A1,COLUMN(A1),1) and copy across as required You will also get the decimal point appearing in a cell of its own.
Hi Jim Try entering in B1 =MID($A1,COLUMN(A1),1) and copy across as required You will also get the decimal point appearing in a cell of its own.
S Stefi Nov 22, 2006 #3 If you don't want the decimal point, use =MID($A1*100,COLUMN(A1),1) Regards, Stefi „Roger Govier†ezt Ãrta:
If you don't want the decimal point, use =MID($A1*100,COLUMN(A1),1) Regards, Stefi „Roger Govier†ezt Ãrta:
R Roger Govier Nov 22, 2006 #4 Good thinking Stefi! -- Regards Roger Govier Stefi said: If you don't want the decimal point, use =MID($A1*100,COLUMN(A1),1) Regards, Stefi "Roger Govier" ezt írta: Click to expand...
Good thinking Stefi! -- Regards Roger Govier Stefi said: If you don't want the decimal point, use =MID($A1*100,COLUMN(A1),1) Regards, Stefi "Roger Govier" ezt írta: Click to expand...
