Forum Discussion
Cell format changes
Good day I have a problem with excel changing cell format from General to Custom from a specific line number when exporting a report into excel. The data that is being exported is fine from the firs...
HansVogelaar thank you for your response. It is a report on a ERP system that is exported as csv. On other computers it exports perfectly fine but this specific one it does not. Is there a setting I can change so that Excel can read all numbers as text as a default perhaps?
Kind Regards
Ryno
And there is no need to change the file extension to ".txt" first.
Simply click Data > From Text to open the Import Text File dialog box.
- Hi Joe
Thank you very much. I tried this method and it seems to work great.
Thank you for responding.
Kind Regards
Ryno