How do I hide text from displaying in cell but not the resulting number from the sum?
="structure,doors,windows:""$"&(SUM(800+900+90))
Thank you for your help.
How do I hide text from displaying in cell but not the resulting number from the sum?
="structure,doors,windows:""$"&(SUM(800+900+90))
Thank you for your help.
Why is the text there at all if you don't want to show it?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I want to know what each figure was for. For example. the 800 is for structure, 900 is for doors, etc. I can see it when I click on it in the future.
Then add a comment to the cell (right-click - insert comment).
Last edited by AliGW; 05-28-2017 at 12:26 AM.
So simple. Thank you.
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Solved!!!!
No, you need to use the Thread Tools at the top to mark it as solved - it's a drop-down option just above the opening post. I have done it for you as a courtesy.
Last edited by AliGW; 05-28-2017 at 12:32 AM.
By the way, here's another way of dong it:
=(SUM(800+900+90))+N("structure,doors,windows")
Thanks for telling me that. I tried to find how to mark solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks