If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format will not save!
Win98SE and WinXP using Excel 2000.
I have a CSV file (audit trail from Sage Accts) which will not allow me to change the format in three particular cells. These cells will always come up in Date Format. I open in Excel, Format the cells, enter the contents ie 3/4521 and I save them in Text Format but just 3 cells in the same column will always revert to Date Format. the other cells are no problem with the same type of content. Any ideas please FS |
#2
|
|||
|
|||
Format will not save!
Hi
I would guess that this is because CSV does not remember cell formats. I suggest either entering the data as '3/4521 - to force a text field - or rename your CSV as TXT and use the text import wizard (which gives you more flexibility on the way the file is brought in) -- Andy. "Fred" wrote in message ... Win98SE and WinXP using Excel 2000. I have a CSV file (audit trail from Sage Accts) which will not allow me to change the format in three particular cells. These cells will always come up in Date Format. I open in Excel, Format the cells, enter the contents ie 3/4521 and I save them in Text Format but just 3 cells in the same column will always revert to Date Format. the other cells are no problem with the same type of content. Any ideas please FS |
#3
|
|||
|
|||
Format will not save!
Many thanks - problem solved
fs "Andy B" wrote in message ... Hi I would guess that this is because CSV does not remember cell formats. I suggest either entering the data as '3/4521 - to force a text field - or rename your CSV as TXT and use the text import wizard (which gives you more flexibility on the way the file is brought in) -- Andy. "Fred" wrote in message ... Win98SE and WinXP using Excel 2000. I have a CSV file (audit trail from Sage Accts) which will not allow me to change the format in three particular cells. These cells will always come up in Date Format. I open in Excel, Format the cells, enter the contents ie 3/4521 and I save them in Text Format but just 3 cells in the same column will always revert to Date Format. the other cells are no problem with the same type of content. Any ideas please FS |
Thread Tools | |
Display Modes | |
|
|