Can Excel ignore a 0 if it starts out that way
Right-click on the cell, go to "format cell";
Under the "number" tab, choose "Custom" in the category mini-window;
In the white space underneath "Type:", replace whatever you have in there
(possibly "General") by "0000000";
Click "OK";
Done!
"Cali Tech" wrote:
I am trying to create a spread sheet and need to enter 0023408 and it wants
to put 23408. I need the 00 to be there. How can I turn this feature on or
off.
|