Home » Category » Microsoft Excel

Microsoft Excel: Zero(0) values box checked-but not displayed as a 1st digit ?

205| Fri, 23 May 2008 18:02:00 GMT| anonymous| Comments (3)
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.

Keywords & Tags: zero, values, box, checked-but, displayed, 1st, digit, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495001/
 
«« Prev - Next »» 3 helpful answers below.
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.

ossiemac | Fri, 23 May 2008 18:03:00 GMT |

I guess you intended 0000 (four zeroes) ?
--
David Biddulph

"OssieMac" <OssieMac...discussions.microsoft.com> wrote in message
news:75176FE2-EC35-4994-ABB6-884708729878...microsoft.com...
> 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.

david | Fri, 23 May 2008 18:04:00 GMT |

Yes it should have been 4 zeros. Thanks David.
--
Regards,

OssieMac

"David Biddulph" wrote:

> I guess you intended 0000 (four zeroes) ?
> --
> David Biddulph
> "OssieMac" <OssieMac...discussions.microsoft.com> wrote in message
> news:75176FE2-EC35-4994-ABB6-884708729878...microsoft.com...
> > 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.
>
>

ossiemac | Fri, 23 May 2008 18:05:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories