3 replies
by s.papcin Accepted solution
by rob miners Accepted solution
FORMATTING CELLS IN EXCEL TO DISPLAY A LEADING ZERO
By default, Excel will not show a leading zero in a cell. If you have a situation where there is a need to display one, each cell that is to contain such a number must be specially formatted.
The process is to open the workbook, highlight the cells to be formatted, and then select from the Menu Bar: Format / Cells / Number / Custom and create the custom number format of 0##### for a six-digit number that will have a leading zero.
When you enter the number 081234, or the number 81234 in a cell so formatted, the display will be 081234 because the formatting requires a leading zero to be displayed. If you enter a number with less than six digits, it will show the digits entered, but with a leading zero.
by thumbsup2 Accepted solution
Use Word's built-in help to figure out how to format mail merge data. Search first on "Format Merged Data". This brings up help which states:
To control aspects of formatting, press ALT+F9 to display field codes (field code: Placeholder text that shows where specified information from your data source will appear; the elements in a field that generate a field's result. The field code includes the field characters, field type, and instructions.) in the main document, and then add switches (switch: When working with fields, a special instruction that causes a specific action to occur. Generally, a switch is added to a field to modify a result.) to the merge fields.
For example:
To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00).
To display the number "0945" as "9:45 PM," add the date/time picture switch (\@ "h:mm am/pm").
To ensure that the merged information has the same font and point size you apply to the merge field, add the \* MERGEFORMAT switch.
At the bottom of that help screen, you'll see "See Also", click to expand it. One of the topics is the numeric picture field switch. Click that to read further.
The numeric picture switch to be used on your zip code with leading zeros, assuming you just wanted a 5 digit zip (without zip+4) would be:
\# 00000
Play with the other options to get zip+4 where that data is provided or suppress it with blanks where it's missing.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending