Forum Discussion
CSV file in Excel - Avoid default round off
Hi Everyone, I have a csv export which has numeric and currency values with 5 decimals places. When I open it in excel, its getting rounded off by default and I need to format the cells for every...
If you double click on CSV when Excel use your regional settings to convert numbers. Thus for currencies it round to 2 decimals, for other numbers cut zeroes. You can nothing to do with that.
An option is to import csv file using Power Query or legacy From Text/CSV wizard and mark such columns as texts.