View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

One way is to type an apostrophe before the first zero......it won't show,
but changes the value to TEXT and displays the leading zeros..........

Vaya con Dios,
Chuck, CABGx3


"Amy" wrote in message
...
I need to have zeros in front of my numbers, but the worksheet keeps

removing
the zeros. I need it to display 007, 042. etc