2

Here is my question? I have an excel worksheet, where inputs are fed by me in the cells. I have a typical situation. When the input value is 0.0, it should show as -- instead of 0. Say in cell B4, I enter a value 0.0, it should show "--". Neither if formula nor conditional formatting helps me here. Any suggestions?

Improve this question
2
  • 1
    You have to use number formatting - the third part of it sets the formatting of a zero, e.g. +0.00, -0.00, -- - but this no question about programming, but instead for Superuser Commented Aug 23, 2022 at 11:11
  • How? Format cell that contain value equal to "0", format number has no effect. I need this to be plain 'dash'. Commented Aug 23, 2022 at 11:16

1 Answer 1

Reset to default
1

format cells -> Custom -> #,##0.0 ; -#,##0.0 ; --

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Yes, this did the trick.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.