So basically I'm comparing two numbers, estimates vs real figures. I need the real figures to show up with and asterisk. And I need the asterisk to be a value in the function in order to pull through to another tab for an output table (formatting asterisks into the cell will not pull through). Right now my text function reads:
TEXT(R26,"_($* #,##0.00_)")&"*"
The problem is this is giving me a currency format still, not an accounting format. So I need the asterisk as a value in the function, in accounting format.
Can someone help me out with this?
Thanks,
Mike
Bookmarks