inserting noughts in cells

N

news freeserve

I am trying to make a numerical list and cannot insert noughts in the cells
eg 0123 everywhere else is fine HELP please this work has to be sent in soon
 
S

Stuart Farr

If it is just a list and you don't need to add the numbers in the list,
then enter '0123 i.e. the number is entered as text.

Hope this is what you wanted
Stuart
 
P

Peter T

news said:
I am trying to make a numerical list and cannot insert noughts in the cells
eg 0123 everywhere else is fine HELP please this work has to be sent in soon
Click to expand...
Format > Cells > Custom > Type 0000 and that preserves number format
filling zeros at the front without converting to text. 0000.00 would
give you 2 decimal places 0000.## would give you 2 decimal places
providing that there weren't any zeros at the end.

HTH
 
Top