kirra's blog

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

Syndicate content