I have a large dataset which has been converted from .csv to .xlsx and I am having trouble with number formatting. I would like to convert values such as 258.325 and/or 1.675.305 to display 25.325 and 16.75305 (so all values have 2 digits before decimal point). Is there a custom number format formula I can use to do this?
It should be noted that I am using excel in a language where the decimal separator is ‘,’ and thousand separator is ‘.’ if that makes any difference.
I have tried using the formula: ?.. This only works for values with the following form: 12.345.678.
1