| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I insert leading zeros?
You shouldn't need to have "leading zero's" Example Cell A1 23 Cell A2 23000 Cell A3 23023 If you want to "SPLIT" your data and you need "leading zero's" to be able to align your text correctly - change your column to 'TEXT' and then you can add leading zero's - otherwise EXCEL will delete them. What you might try also to "align" your text to be able to split it is - Select your Column and then "RIGHT JUSTIFY" the TEXT - The right justify is on the MENU BAR as an icon. Be sure you also use the COURIER FONT - then you can see how things "really" line-up. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=522368 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| Insert Leading Zeros | Excel Worksheet Functions | |||
Hybrid Mode
