Display Character from number
Hello...everybody
I need help...with display symbol or special character from number. Example: I have a number "1" in cell A1, I want display it special char e.g left arrow to replace "1" using formatting cell.
anybody can show me how do that..
Rgd's
Harson
Use Wingdings 2 font or Conditional Formatting
Go through the below links to know how to achieve it.
https://www.xelplus.com/excel-condit...tting-symbols/
https://exceljet.net/formula/validat...ith-check-mark
https://www.computergaga.com/blog/di...e-if-function/
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks...for quick response but I was forget to inform you that content of cell was result "count" pivottable..and so I couldn't direct edit on cell to write formula. I think it make sense to use conditional formating apply to range cell of pivottable..
maybe...have you others technique to resolve it?
Yes, Pivot Table is the best suited solution for your scenario.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks