Hey Chip
I'm doing an upload that requires a "number" format. However, alot of the
numbers have leading zeroes. Is "custom" 0000 considered a "number"
formatted field.
"Chip Pearson" wrote:
Use a custom number format of 000000 or as many zero as you need.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Shadyhosta" wrote in
message
...
I often deal with account numbers with leading zeros. When I
place them in a
cell Excel automatically deletes the leading zeros. Is there a
way to format
the cell to hold the zeros?