Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please help.
I have a large excel sheet with the columns looking as follows: A B C D E 207,803, 209 9 44,946, 2527,571, 296900,873, 291158,381, 210,000, 209 12 44,228, 2527,571, 296899,802, 291156,463, 214,643, 209 19 3,160, 2527,571, 296897,532, 291152,412, 216,818, 209 22 0,637, 2527,571, 296896,466, 291150,516, What I need to do is make the columns do look like the following but without have to go to each cell to edit the contents, i.e putting +signs in column A before last 3digits, putting decimal place in front of the last 3digits in column B, C, D & E and removing the commas throughout. There a thousands of these figures that will be inputted on an ongoing basis so I need to customize each column so only figures need to be inputted and not various symbols. 0+000 65 18 0.310 Straight 296568.808 290861.845 1+287 65 18 0.310 Straight 296569.977 290862.382 10+000 65 18 0.310 Straight 296577.893 290866.023 12+023 65 18 0.310 Straight 296579.731 290866.869 20+000 65 18 0.310 Straight 296586.978 290870.202 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format cells to show date in Australian not US format? | Excel Worksheet Functions | |||
Bottom double border from toolbar-customize format not working | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) |