C Ch3misTry Mar 11, 2008 #1 it always converts to 10 when i type 0010 . . how to change the setting ? ? ? some excel pro please help me !
it always converts to 10 when i type 0010 . . how to change the setting ? ? ? some excel pro please help me !
M Max Mar 11, 2008 #3 it always converts to 10 when i type 0010 . . Another way, if you don't mind it as text, is to either precede the input with an apostrophe ('), or perhaps easier, just pre-format the data entry range as: Text ---
it always converts to 10 when i type 0010 . . Another way, if you don't mind it as text, is to either precede the input with an apostrophe ('), or perhaps easier, just pre-format the data entry range as: Text ---
