either format the cells as text or type ' before the number
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"jay" wrote:

i am dealing with product numbers that start with leading zeros. Excel by
default treats these as numbers, and leaves out the zeros.
Is there a way to set the default format in a new document to text, so that
excel will keep those zeros?
thanks
jay