Excel save as .txt
Hi! I need help !!!
I have a spreadsheet in Excel that I'm trying to save as .txt or .csv to be able to import the data into myob.
However, every time I save as .txt or .csv and open it in notepad it doesn't show the data separated by comma, it's separated by tab which it's not the format accepted into myob.
What's happening ?? Am I doing something wrong ?? What should I do ??
I tried to concatenate the data too but it changes the date and numbers format...
I have a spreadsheet with columns heads: date, invoice no, description... and I need every column in one line separated by comma
Thank you !!!
- kirra's blog
- Login or register to post comments
- 4018 reads
have u tried the
have u tried the following:
1. Create new workbook (CTRL + N)
2. Copy the data you want to save
3. Select the new workbook
4. Paste special values
5. File => Saveas
6. Choose File SaveAs type: CSV
7. Save... ignoring warnings