Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to retain leading zeros i.e. 00001 instead of 1
I need to set up a spreadsheet for a mail merge, so that it prints 00001,
but of course it defaults to 1. How do I show the 0s? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to retain leading zeros i.e. 00001 instead of 1
Use a custom format of 00000.
Does this help? -- Regards, Fred "Sue" wrote in message ... I need to set up a spreadsheet for a mail merge, so that it prints 00001, but of course it defaults to 1. How do I show the 0s? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to retain leading zeros i.e. 00001 instead of 1
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. Sue wrote: I need to set up a spreadsheet for a mail merge, so that it prints 00001, but of course it defaults to 1. How do I show the 0s? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros when uploading a number from text file | Excel Discussion (Misc queries) | |||
Leading Zeros | Excel Discussion (Misc queries) | |||
retain leading zeros when importing | Excel Discussion (Misc queries) | |||
CSV File - Leading Zeros | Excel Discussion (Misc queries) | |||
retain leading zeros in number format | Excel Discussion (Misc queries) |