Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If it's small changes you need to make, I think you're better off using
Notepad to edit it rather than using Excel. Excel is known to automatically remove leading zeros, and sometimes merge consecutive empty columns upon opening. -Simon "Shmuel" wrote: I am importing the .csv file into another software. Before I make any changed in the file it is being imported fine (each cell of the file goes to the right position into the software I am importing to). But after I make any small shanges in the file (like change one number) and save it (after promt comes up with the worning that the saved file would not have feature of csv file) the imported file does not place the data in the right position on the software. "Andy" wrote: Hi Shmuel What do you mean by 'the file is messed up'? Saving it as a CSV will just take the data in each cell and save it all, separated by commas - with no formatting. This means you can open the file in just about any program - including Notepad. Andy. "Shmuel" wrote in message ... I have a .csv formated file that should be modified. After any modfication or any changes of this file I cannot save it in .csv format. The message come up saying that the .csv file may contain featires that are not compatible with csv. If I still save it it being saved as .csv format, but the file is messed up. How would I save the file so it would be compatible? Thank you, Please describe in detailes as I am not a pro. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I keep an excel file from saving to "COPY OF" file name | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
Problem saving the file after moving worksheets into another | Excel Discussion (Misc queries) | |||
Automatic File Saving | Excel Discussion (Misc queries) |