| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Zero's # 2
Hi Delaina-
In addition to these other fine suggestions, you can also create a custom format of 00-0000000 (even include it as part of a Style). One advantage being that the dash need not be typed. Regards |:) "swatsp0p" wrote: As an aside, you could format your ID cells as TEXT before entering data. Excel will then keep leading zeros, hyphens, etc. Good Luck -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=478855 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
| Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| replacing only zeros | New Users to Excel | |||
| Excel file saved as csv - dropping zeros | Excel Discussion (Misc queries) | |||
Threaded Mode
