Dec 31 2018 09:32 AM
I am trying to change a value to represent a millions currency. Example the number data was 1,878,455.61 and I need excel format to change it to $1.88 or $365,676.43 to $0.37.
I am having difficulty with formatting the cell to represent the sample.
Dec 31 2018 09:51 AM
I have tried changing the number to currency and was unsuccessful.
Jan 02 2019 07:26 AM
You may apply custom number format like this (two commas at the end for millions)
More about formats is here https://exceljet.net/custom-number-formats