Show all values as positive
Is there a way to show all values in a cell as positive, even if a negative value?
Last Comment
Qlemo
Just use a custom cell format, like "###.###.###;###.###.###;"
Try this custom cell format...
#,###;#,###;General
#,###;#,###;General
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Because that requires to use a formula, instead of leaving the cell content alone?
ASKER
Worked perfectly!
@daisypetals
Thanks for giving us a lesson that we should not waste our time to answer a question if it is not asked properly but asked like a puzzle. :)
Thanks for giving us a lesson that we should not waste our time to answer a question if it is not asked properly but asked like a puzzle. :)
ASKER
Thanks sktneer. I appreciate that you took the time to come back here and write that. It's very helpful to everyone reading this question that may have the same inquiry.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
