If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|