View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default How do I get excel to leave a zero in front of a number?

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

Format Cells Text

Then type the number in.

--
Allllen


"elmo" wrote:

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.