Home

Number Formatting

Highlighted
dnique2018
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
Highlighted

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

Highlighted

You may apply custom number format like this (two commas at the end for millions)

image.png

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