show 0 in front of number in Excel 0678

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

Guest

trying to enter a number that starts with a zero, and would like the zero to
stay. ie 0678
 
Two ways:

1. precede your entry with an apostrophe (single quote)
2. Format > Cells... > Number > Custom
0000

You can apply the second method to data already entered.
 
You must log in or register to reply here.

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

How do I put spaces in a field 1
Analyzing Numbers 1
Displaying zeros in cells 2
how to show numbers that begin with 0 in excel 2
How to arrange number? 9
Excel Number Format Question 2
How do I remove the apostrophe(') in front of zeros 3
sum last 3 numbers greater that 0 in a range 0

Back
Top