Parce a number with decimals into separate columns
 

I want to parce a number like "123.45" so that the 1, 2, 3, 4 and 5 are in
separate cells.

Parce a number with decimals into separate columns
 

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.


--
Regards

Roger Govier


"JimR" wrote in message
...
I want to parce a number like "123.45" so that the 1, 2, 3, 4 and 5 are
in
separate cells.

Parce a number with decimals into separate columns
 

If you don't want the decimal point, use
=MID($A1*100,COLUMN(A1),1)

Regards,
Stefi

€žRoger Govier€� ezt Ã*rta:

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.


--
Regards

Roger Govier


"JimR" wrote in message
...
I want to parce a number like "123.45" so that the 1, 2, 3, 4 and 5 are
in
separate cells.

Parce a number with decimals into separate columns
 

Good thinking Stefi!

--
Regards

Roger Govier


"Stefi" wrote in message
...
If you don't want the decimal point, use
=MID($A1*100,COLUMN(A1),1)

Regards,
Stefi

"Roger Govier" ezt írta:

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.


--
Regards

Roger Govier


"JimR" wrote in message
...
I want to parce a number like "123.45" so that the 1, 2, 3, 4 and 5
are
in
separate cells.