| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging separate date and time columns into one | Excel Discussion (Misc queries) | |||
| Join three columns containing phone number and format as (000) 000 | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
| concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
| set number of rows equal in mutiple columns | Excel Discussion (Misc queries) | |||
Linear Mode
