Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I cannot find an answer to this problem anywhere, perhaps someone here can
help. I have 2 columns of data that I pulled from my proprietary database using ODBC. The first column is part numbers, and the second is a list price for the part. The part numbers are a mix of numbers, letters, and some dashes. I am saving this list to a .csv, uploading it to my web server, and then logging in to my webserver and importing the data from the .csv to a mysql database. The problem is coming in when I have part numbers that start with zero. An example would be 010888. The zero gets dropped off when I save it as a .csv. I figured I could convert it to text and it would be fine but when I convert it to text in excel it drops the zero too. A part number like 010888L is fine because its treated like text and the zero remains through any conversion. Please help.. I have some 9000 part numbers that I need to save to a .csv and 300 of them start with zero. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert text number to number formate | Excel Discussion (Misc queries) | |||
first number after zeroes in sequence | Excel Worksheet Functions | |||
Convert Text to Number | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions |