how do i show a zero in front of a number ie 0625 in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to enter numbers in excel, and would like to see the 0 in front
of the number ie 0625
 
If you want numbers to show leading zeros for 4 digits then format the cells
as Custom 0000.

625 will display as 0625
1 will display as 0001

etc.
 
Thanks for the help - hjt

Gary''s Student said:
If you want numbers to show leading zeros for 4 digits then format the cells
as Custom 0000.

625 will display as 0625
1 will display as 0001

etc.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to put two Rows together 1
function for pulling certain numbers from a cell? 3
Cells.Find: Why can't I pass a variable? 10
Excel error in converting decimal to fraction 3
Displaying zeros in cells 2
How do I remove the apostrophe(') in front of zeros 3
How to arrange number? 9
Access Tidy up phone numbers 0

Back
Top