0987 show in the cell - the zero drops off-ned all 4 digits

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeR-Oz - 23 Feb 2008 21:50 GMT

I type in 0987 in the top bar and yet I press enter the number in the row
cell shows 987 and the top bar no longer has the zero.

I looked at format and i have tried number , general, custom etc -- HOw to
get the zero and all four digits to show?

Thanks
Mike

Reply to this Message

Nick Hodge - 23 Feb 2008 22:10 GMT

Mike

Format as text and it will stay or lead with a single apostrophe. (It will
not show) or if the numbers are all four digits long format it via
Format>Cells...>Custom and enter 0000 (the number below will still actually
be the number without the leading zero, but the display will be fine.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> I type in 0987 in the top bar and yet I press enter the number in the row
> cell shows 987 and the top bar no longer has the zero.
[quoted text clipped - 4 lines]
> Thanks
> Mike

Reply to this Message

MikeR-Oz - 23 Feb 2008 23:09 GMT

Thanks Nick - used the second option which I never new about fully.

Cheers
MIke

> Mike
>
[quoted text clipped - 11 lines]
> > Thanks
> > Mike

Reply to this Message