Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel dilema
i type 041 in excel it becomes 41 i need to keep the 0. help?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Dilema detail | Excel Discussion (Misc queries) | |||
IF Dilema | Excel Discussion (Misc queries) | |||
sorting dilema | Excel Discussion (Misc queries) |