S
sam23
i type 041 in excel it becomes 41 i need to keep the 0. help?
M
Mike Rogers
Format the cell as text or preceed your entry with an apostrophy.
Mike Rogers
Mike Rogers
S
sam23
Thank you!!
i never thought of formatting the cell as text...you are a genius!!!!
i never thought of formatting the cell as text...you are a genius!!!!
S
steve_doc
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
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