| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep Leading zeros in .CSV file saved as from .xls file
I am using VBA for saving one worksheet as .csv file format from a Excel
workbook .One of the columns in that contains values as 00033 and so on.When my save as statement in vba code executes then i lost the leading zeroes from that column and finally get only 33 . Is there any way by which i can keep leading zeroes in that perticuler column. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i keep Leading zeros in .CSV file saved as from .xls file
Rename the file a .TXT file and then import. Excel will give you options to choose between Date, text, number, etc.
-- Kind regards, Niek Otten "Vikas" wrote in message ... I am using VBA for saving one worksheet as .csv file format from a Excel workbook .One of the columns in that contains values as 00033 and so on.When my save as statement in vba code executes then i lost the leading zeroes from that column and finally get only 33 . Is there any way by which i can keep leading zeroes in that perticuler column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i save a csv file to keep leading zeros please? | Excel Discussion (Misc queries) | |||
| How do I open a csv file and not have leading zeros eliminated | Excel Discussion (Misc queries) | |||
| Loosing Leading zeros in CSV file | Excel Discussion (Misc queries) | |||
| CSV File - Leading Zeros | Excel Discussion (Misc queries) | |||
| droping leading zeros when writing to a file | Excel Programming | |||
Linear Mode
