| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero(0) values box checked-but not displayed as a 1st digit ?
I am working on a spreadsheet in Excel, however I can not get the zero(0) to
display in the cell as a first digit of a number. Example: 0319 is displayed as 319. I checked the zero values box under Tools, Options, View and that did not work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Zero(0) values box checked-but not displayed as a 1st digit ?
Select the range where you want the leading zeros and then select menu item
Format-Cells then Select Number Tab. Click on Number then Custom in the list. In the box under Type: Edit it to 000 (That's three zeros) zero values box under Tools, Options, View only tells Excel whether or not to display cells containing zero value; not zeros in a number. -- Regards, OssieMac "BoyBaby" wrote: I am working on a spreadsheet in Excel, however I can not get the zero(0) to display in the cell as a first digit of a number. Example: 0319 is displayed as 319. I checked the zero values box under Tools, Options, View and that did not work. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Zero(0) values box checked-but not displayed as a 1st digit ?
I guess you intended 0000 (four zeroes) ?
-- David Biddulph "OssieMac" wrote in message ... Select the range where you want the leading zeros and then select menu item Format-Cells then Select Number Tab. Click on Number then Custom in the list. In the box under Type: Edit it to 000 (That's three zeros) zero values box under Tools, Options, View only tells Excel whether or not to display cells containing zero value; not zeros in a number. "BoyBaby" wrote: I am working on a spreadsheet in Excel, however I can not get the zero(0) to display in the cell as a first digit of a number. Example: 0319 is displayed as 319. I checked the zero values box under Tools, Options, View and that did not work. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Zero(0) values box checked-but not displayed as a 1st digit ?
Yes it should have been 4 zeros. Thanks David.
-- Regards, OssieMac "David Biddulph" wrote: I guess you intended 0000 (four zeroes) ? -- David Biddulph "OssieMac" wrote in message ... Select the range where you want the leading zeros and then select menu item Format-Cells then Select Number Tab. Click on Number then Custom in the list. In the box under Type: Edit it to 000 (That's three zeros) zero values box under Tools, Options, View only tells Excel whether or not to display cells containing zero value; not zeros in a number. "BoyBaby" wrote: I am working on a spreadsheet in Excel, however I can not get the zero(0) to display in the cell as a first digit of a number. Example: 0319 is displayed as 319. I checked the zero values box under Tools, Options, View and that did not work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate alphanumeric unique 4 digit values from 12 digit values | Excel Worksheet Functions | |||
| Comparing displayed values | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Can I insert a box on excel that can be checked and un-checked? | Excel Discussion (Misc queries) | |||
| displayed cell values | Excel Worksheet Functions | |||
Linear Mode
