MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
I want to put an asterisk after some values in my worksheet to highlight an issue so people know to look at the explanatory notes. If I just do this by adding &"*" to the end of the formula then Excel displays the full value to several decimal places, so instead I've used this:
=ROUND(other formula,2)&"*"
However, I have a value that rounds to 3.60 and in this case the above formula displays 3.6* rather than 3.60*. Is there a better way of doing this to achieve the desired result? And yes I know I could use something other than an asterisk, but that's what fits in with the format of the report it's going in.
Change the number format to include the *
=TEXT(ROUND(other formula,2),"#.00")&"*"
edit: beaten to it by jfletch
Thanks, that did the trick nicely, much obliged.
if you add [$*] to the end of your number format it'll work a treat - then you can treat it like a number still
ie
#,##0.00[$*]
^Also very elegant - again, thanks!