Hello,
I'm trying to format a cell that is referencing another cell in another sheet, to round to the nearest 1,000 and add 'M' to the end of the number.
For example, B6 in my primary sheet is referencing B6 in my Data sheet (=Data!6). It currently shows a currency amount, ex; $387,691. What I would like for it to show is $388M (rounding to the nearest 1,000 truncating the rest and adding M to the end while still referencing the other cell.
Hope this is possible, thanks for the help!
Running Crystal 11 - 14.0.2.364
I'm trying to format a cell that is referencing another cell in another sheet, to round to the nearest 1,000 and add 'M' to the end of the number.
For example, B6 in my primary sheet is referencing B6 in my Data sheet (=Data!6). It currently shows a currency amount, ex; $387,691. What I would like for it to show is $388M (rounding to the nearest 1,000 truncating the rest and adding M to the end while still referencing the other cell.
Hope this is possible, thanks for the help!
Running Crystal 11 - 14.0.2.364