Number Formatting

New Contributor

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. 




2 Replies

I have tried changing the number to currency and was unsuccessful. 


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

Related Conversations
Cell Validation - Drop Down Lists and Text Formatting
JenSmith in Excel on
1 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Relative conditional formatting
melissach in Excel on
8 Replies
Column Formatting - Render html
TrevorStyler in SharePoint on
0 Replies