Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace leading zeros with leading spaces ?
I am using Excel 2007.
Format (12,000) gives me 012 I want (12,??0) to be 12 with a leading space Question mark doesnt seem to work in Excel 2007 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPLACE command drops leading zeros | Excel Discussion (Misc queries) | |||
Using REPLACE command removes leading zeros | Excel Discussion (Misc queries) | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
How do I add leading spaces to a value? | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |