The Number Zero won't display when entered into a cell (excel) - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

The Number Zero won't display when entered into a cell (excel)

MarzBarz Avatar
8y, 1w agoPosted 8 years, 1 week ago
I am working within a excel spread
When I enter the number "0" at the beginning it will not show. An example is 01267589658 but once inputted it shows as 1267589658?

I have opened a new spread sheet - no problem. I have checked font colors,
checked using the number and general options - this doesn't resolve the
issue.

Suggestions

Thanks
MarzBarz Avatar
8y, 1w agoPosted 8 years, 1 week ago
Options

All Comments

(19) Jump to unreadPost a comment
Comments/page:
banned 1 Like #1
You have to change the format...right click on the cell and change the format to custom and pick the correct option..forget the one it is and I dont have Excel loaded on home PC...so cant remember the exact one for you to pick
1 Like #2
format cells > custom > type = 0

I think.
1 Like #3
Try typing a ' first ie '01234

I'm sure this will work :thumbsup:
1 Like #4
Try prefixing it with '
Perhaps?
1 Like #5
Right click in cell
Format cells
Text


It will now let you enter the leading zero but will be left justified
#6
emasu
format cells > custom > type = 0

I think.


Hmmm odb and emasu tried this but still the same. So i tried text instead and it works. Do you think ill have any problems importing it to access?
#7
choc1969
Right click in cell
Format cells
Text


It will now let you enter the leading zero but will be left justified


yep just tried that :thumbsup: but u reckon ill get any problems when importing it in access.
#8
MarzBarz;3616946
yep just tried that :thumbsup: but u reckon ill get any problems when importing it in access.


shouldn't be a problem, you can change the imported format in access of it does but I've never experienced it :thumbsup:
1 Like #9
Will most probably be a problem exporting to most things if you use the ' method.

The correct way is to fix the length of input, go to format cells/custom then click the "0" option and type in "00000" to enable 00123 for example.
#10
ok thanks repped all :)
banned#11
pghstochaj
Will most probably be a problem exporting to most things if you use the ' method.

The correct way is to fix the length of input, go to format cells/custom then click the "0" option and type in "00000" to enable 00123 for example.



There is defo another way the problem with that method is you are set to a specific amount of characters...wheras the other way you can do anything...



Sorry Marz lad..if I was at work with it in front of me I could answer you in 30 seconds...I do this stuff everyday I just dont have it at home
#12
Setting to text should work if your just inputting the numbers by hand
banned#13
I thought it was a case of entering # in the cell formatting so that it always displays at least one character. (Or #.# if you want it to have a single decimal place)
banned#14
Titchimp
Setting to text should work if your just inputting the numbers by hand


Only problem with that (and I agree it would do it) is that you couldnt then use the cell content to add totals etc or use formulas.
banned#15
guv
Only problem with that (and I agree it would do it) is that you couldnt then use the cell content to add totals etc or use formulas.


yup wont work with certain things
#16
put a full stop at the beginning, dont know why it works but it does. keeps the 0 at the start and the full stop disappears
#17
ODB_69
yup wont work with certain things


Of course it would, loads of ways, including value(x) or RIGHT(x) and so on.
#18
question is why do you want to do this, if u want to do it for a label then text will do, if you want to perform math on this cell then it's not advised.
but then again if you want to perform math on this cell why would you want to show a 0
#19
Im inputting phone numbers lol. Ive done it now by the text method and used a random excel number generator to fill it in.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!