| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zero not displaying
I am trying to merge an excel doc into a word doc. I have formatted the cell
in excel to show a leading zero. Specifically I am talking about leading zeros for zip codes. I can get the zero to show in the cell itself. I can't get it to show in the "Fx" line. And when I mail merge the sheet to word it also does not show the leading zero. I have formatted the cell to show zip codes, I have tried formatting the cell as text, and I have formatted the cell with custom formatting. Nothing has worked. Any help would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
leading zero not displaying
Found the answer, was asking the wrong question in the help menu.
"ftjackson" wrote: I am trying to merge an excel doc into a word doc. I have formatted the cell in excel to show a leading zero. Specifically I am talking about leading zeros for zip codes. I can get the zero to show in the cell itself. I can't get it to show in the "Fx" line. And when I mail merge the sheet to word it also does not show the leading zero. I have formatted the cell to show zip codes, I have tried formatting the cell as text, and I have formatted the cell with custom formatting. Nothing has worked. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping leading 0's | Excel Discussion (Misc queries) | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Remove leading space | Excel Worksheet Functions | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
