| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep 0 in front of # in excel (ex: 018787766316)
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??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Threaded Mode
