Link to home
Create AccountLog in
Microsoft Excel

Microsoft Excel

--

Questions

--

Followers

Top Experts

Avatar of daisypetals313
daisypetals313🇺🇸

Show all values as positive
Is there a way to show all values in a cell as positive, even if a negative value?

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of QlemoQlemo🇩🇪

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).
Avatar of Subodh Tiwari (Neeraj)Subodh Tiwari (Neeraj)🇮🇳

Try this custom cell format...

#,###;#,###;General
ASKER CERTIFIED SOLUTION
Avatar of bbaobbao🇦🇺

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of QlemoQlemo🇩🇪

Because that requires to use a formula, instead of leaving the cell content alone?
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of daisypetals313daisypetals313🇺🇸

ASKER

Worked perfectly!
Avatar of Subodh Tiwari (Neeraj)Subodh Tiwari (Neeraj)🇮🇳

@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. :)
Avatar of daisypetals313daisypetals313🇺🇸

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.
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Microsoft Excel

Microsoft Excel

--

Questions

--

Followers

Top Experts

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.