We have a system which is sensitive to decimals when importing a csv statement;
- the decimal separator need to be converted from our standard “,” to “.” and
- every converted number need to have 2 decimals.
When changing decimal separator from standard “,” to “.” the decimals which are 00 disappear.
Is there a way to keep 2 decimals, whatever number, when changing the decimal separator?
If not, is there a CONCATENATE formula which I can use to add the missing zeros after converting?
Thank you for any suggestions.