Show all values as positive

daisypetals313
daisypetals313 used Ask the Experts™
on
Is there a way to show all values in a cell as positive, even if a negative value?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Just use a custom cell format, like "###.###.###;###.###.###;". The meaning is "postive;negative;zero", so my mask will not display zero (but show as empty cell).
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Try this custom cell format...

#,###;#,###;General
IT Consultant
Commented:
why not to use function ABS(), which converts any number to positive?
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Because that requires to use a formula, instead of leaving the cell content alone?

Author

Commented:
Worked perfectly!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
@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. :)

Author

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial