| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format for Leading Zeros
Thanks, everyone. I actually only needed to do the A column. I probably did not make that clear. The suggestions were still helpful. This works for just one column: ..Range("A5:A798").numberformat="000000" -- DavidW ------------------------------------------------------------------------ DavidW's Profile: http://www.excelforum.com/member.php...o&userid=32630 View this thread: http://www.excelforum.com/showthread...hreadid=534117 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros in text format | Excel Discussion (Misc queries) | |||
| leading zeros fall off in csv format. | Excel Discussion (Misc queries) | |||
| How do I keep leading zeros and format my cells as text? | Excel Discussion (Misc queries) | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
![DavidW[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
