excel dilema
 

i type 041 in excel it becomes 41 i need to keep the 0. help?

excel dilema
 

Format the cell as text or preceed your entry with an apostrophy.

Mike Rogers

--
The only dumb question is the one you did not ask.


"sam23" wrote:

i type 041 in excel it becomes 41 i need to keep the 0. help?

excel dilema
 

Thank you!!
i never thought of formatting the cell as text...you are a genius!!!! :)

"Mike Rogers" wrote:

Format the cell as text or preceed your entry with an apostrophy.

Mike Rogers

--
The only dumb question is the one you did not ask.


"sam23" wrote:

i type 041 in excel it becomes 41 i need to keep the 0. help?

excel dilema
 

Further to Mike's sugestion

You could set a custom Format to include the leading 0
Select Cells - Format/Cells/Custom
0##
Should work
Depending on how large the number you are entering, above eg will work up to
100
0### will work up to 1000 etc

HTH

"sam23" wrote:

Thank you!!
i never thought of formatting the cell as text...you are a genius!!!! :)

"Mike Rogers" wrote:

Format the cell as text or preceed your entry with an apostrophy.

Mike Rogers

--
The only dumb question is the one you did not ask.


"sam23" wrote:

i type 041 in excel it becomes 41 i need to keep the 0. help?