| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to keep leading zero without changing field to text field?
I've already tried to customize the number 0#### - the leading zero remains
in Excel but as soon as I save this file and try to use it as a merge document with word the leading zero is gone again. I then have to go back and make this a text in order for the zero to remain when merging with word. |
|
#2
|
|||
|
|||
|
How to keep leading zero without changing field to text field?
http://office.microsoft.com/en-ca/as...164951033.aspx
-- tj "Deni" wrote: I've already tried to customize the number 0#### - the leading zero remains in Excel but as soon as I save this file and try to use it as a merge document with word the leading zero is gone again. I then have to go back and make this a text in order for the zero to remain when merging with word. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
| How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
Linear Mode
