Question: My Excel file has a column, say, PercentageColumn, that is formatted with data type as percentage. For example it displays 13.4526961728569 as 13.45%. How can we make sure that when saving Excel file as csv, it keeps the actual numeric values (like 13.4526961728569) in PercentageColumn column (instead of its display value like 13.45%).
I’m using latest version of Excel (in Microsoft 365).