inserting noughts in cells

  • Thread starter Thread starter news freeserve
  • Start date Start date
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
 
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
 
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
 
Back
Top