View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Reed Jim Reed is offline
external usenet poster
 
Posts: 4
Default How to keep 0 in front of # in excel (ex: 018787766316)

Try formatting the cell as text before entering the data.

--

"Rob" wrote in message ...
I have a UPC code I am trying to upload to nextag. When I convert the UPC
code to Numbers or Text and then save the file as .csv for uploading, the
first digit of the UPC code disappears.

Ex: 0-18787-76631-6 I have to remove all dashes, apostrophes, etc, as per
Nextag specs, and in order for the zero to remain as the first digit I have
to convcer the formatting of the cell to text, but when I save the file for
upload the zero drops off, and I am left with 18787766316, which results in
an error. Any ideas???