Hi,
I am trying to convert a number in millions but shown as a thousand to the nearest decimal point and then add "M" to the end of the converted number.
I understand the formula to divide by 1000 and then use the ROUND function to get one decimal point,but when I concatenate the "M" at the end I loose my dollar sign.
Does any one know a work around for this?
Example:
So $2,150 is converted to $2.150 and then rounded to $2.2 then displayed as $2.2M
This needs to remain dynamic so when the data in the sheet is updated the number updates to the correct format.