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!