Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modification of a .CSV file
Hi,
I need to do some changes in a .CSV file. I have two different changes to make: 1) convert the string 111E+112 (scientific notation) to 00111E110 (string with the zeros at the beginning) 2) convert the number 1234567 to 0001234567 - I need to keep the zeros at the beginning My problem is that, when I do the changes and save the file back in .CSV format, all the changes are gone, they are not saved. It's probably because of the format specifics but I really don't know how to deal with the problem. I need to find a way to save those change in a .CSV format. Does somebody know how to bypass this issue? Thanks much, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Modification | Excel Worksheet Functions | |||
last modification | Excel Discussion (Misc queries) | |||
MODIFICATION IS NOT ALLOWED | Excel Worksheet Functions | |||
Last Modification Date | Excel Worksheet Functions | |||
Excel file modification date | Excel Discussion (Misc queries) |