View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Ean Wilson[_2_] Ean Wilson[_2_] is offline
external usenet poster
 
Posts: 7
Default How can can I enter 023023 in a cell without losing the first

Works for me! Thanks. :)

"Ron Rosenfeld" wrote:

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