Last answered:

01 Feb 2024

Posted on:

01 Feb 2024

0

Resolved: how to obtain the dash (-) sign

I keep getting 0.0 on the last check row after using the round formula instaed of the dash sign. How do I change that?

2 answers ( 1 marked as helpful)
Instructor
Posted on:

01 Feb 2024

0

Hello,

One way to do that is to use the ROUND function. 


Please take a look at the full number going beyond 4-5 symbols after the decimal separator. If you see 0s then most likely this is a frequent Excel bug and you shouldn't worry about that.


Best,
Ned

Posted on:

01 Feb 2024

0

Thank you Ned, indeed a bug as I tried rounding beyong 5 symbols. Thank you

Submit an answer