Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
0987 show in the cell - the zero drops off-ned all 4 digits
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
0987 show in the cell - the zero drops off-ned all 4 digits
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 FormatCells...Custom and enter 0000 (the number below will still actually be the number without the leading zero, but the display will be fine. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MikeR-Oz" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
0987 show in the cell - the zero drops off-ned all 4 digits
Thanks Nick - used the second option which I never new about fully.
Cheers MIke "Nick Hodge" wrote: 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 FormatCells...Custom and enter 0000 (the number below will still actually be the number without the leading zero, but the display will be fine. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MikeR-Oz" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Truncating numbers to show last three digits | Excel Discussion (Misc queries) | |||
My Cell drops the Zero if it is first. | Excel Discussion (Misc queries) | |||
formula locates common data in a cell and drops them in other shee | Excel Discussion (Misc queries) | |||
Combo Box - Show only first two digits? | Excel Discussion (Misc queries) | |||
How do I shorten 10-digit # so only 6 digits show up? | Excel Discussion (Misc queries) |