Thread: How can can I enter 023023 in a cell without losing the first 0
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How can can I enter 023023 in a cell without losing the first 0
On Mon, 15 Oct 2007 04:14:02 -0700, Frustrated
wrote:

Hi, does anybody know how I can enter the number 023023 in a cell without
automatically losing the first zero ?

Format the cell:

Format/Cells/Number/Custom Type: 000000


--ron
Reply With QuoteReply With Quote