View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FiluDlidu FiluDlidu is offline
external usenet poster
 
Posts: 66
Default 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.