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
|