How do I get excel to leave a zero in front of a number?

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

Guest

I am trying to list bus numbers for my students and excel won't let me type
0176. It keeps taking away the zero and leaving 176. I even tried putting a
decimal point in front and then it added a zero 0.0176.
 
type this way:

'0176

add ' in front of numeric value, then those numeric value will convert to
text format

do rate pls
 
Before you type in the number, format the cells as text.

Format > Cells > Text

Then type the number in.
 

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 remove the apostrophe(') in front of zeros 3
In excel how do i get from this 44345678912 to this 0345678912 us. 2
I want to display numbers with zeros in front of them, eg 005 8
How to stop Excel from automatically truncating leading zeros 2
Replacing cell numbers but leaving leading zero 1
trying to insert a 0 in front of zipcode 2
How to retain decimal zeroes? 5
how do you get excel to leave zero,s after the decimal point? 3

Back
Top