I need to convert a column of numbers currently formatted with 2 decimal places e.g. 112.12 to 4 decimal places (without the decimal point)
I need the end result to be 1121200
I've tried a few different suggestions given on the forum previously but can't seem to retain the 4 decimal places that I require.
Appreciate any help. Thanks.
Bookmarks