I'm trying to do a custom number formatting to where I can put in formulas and not get it to display the equation. So right now I have it set as "Total "@ and it works fine for text but if I put a formula in then I get an output of "Total =A1". Is there a format that will get it to display the value instead of the formula?
Have you tried using a number format code in place of the text format code? Something like "Total "General or "Total "$0.00 or whatever the appropriate number format would be?
Originally Posted by shg
No, because I don't fully know what I'm doing.
Hahaha. 10/10 for honesty!!!
TbH... I don't quite understand what you want to do. Can you SHOW us on a sample Excel file?? (See yellow banner at top for guidelines, etc)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Attachment 736656
Just attached a screenshot because it fully shows what I'm trying to do
Try ="Total " &C3
That defeats the purpose of what I'm trying to do. It works for individual cells but if I have to manually put it in for each one then I should just keep my current format and paste in the text.
I do not understand what you want to do. Post a sheet (not a picture) showing what you want in SEVERAL cells.
Accidently just figured out what I was trying to do by making an example. I wanted to have every unique cell +"Total". So it ended up being ="Total "&UNIQUE(A1:A5). Your previous example ended up helping me there though so thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks