amandabstewart
New Member
- Joined
- Aug 4, 2014
- Messages
- 45
I have a column formatted to not show zeros, but I can't get it to show the two decimal places I need. It rounds to a whole number.
Any ides?
Amanda
Any ides?
Amanda
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cell formatting for not showing zero BUT allowing 2 decimal places
- Thread starter amandabstewart
- Start date
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
Hi Amanda,
You could try this Custom NumberFormat:
#,##0.00;-#,##0.00;
You could try this Custom NumberFormat:
#,##0.00;-#,##0.00;
Upvote
0
amandabstewart
New Member
- Joined
- Aug 4, 2014
- Messages
- 45
AWESOMEEEEEE. Thank you so much Jerry! Works perfectly!
When I see how easily you fixed this...it makes me : ( that I'll never know Excel like I want to know it.
When I see how easily you fixed this...it makes me : ( that I'll never know Excel like I want to know it.
Upvote
0
