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

E

elmo

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.
 
M

Muhammed Rafeek M

type this way:

'0176

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

do rate pls
 
A

Allllen

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

Format > Cells > Text

Then type the number in.
 
Top