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 !!!

Nick's picture

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