![]() |
Displaying zeroes in decimals
I need to display numbers like "1.0" and 2.0" and I can't get around the
auto-correct that changes them to "1" and "2". How do I do this? Thanks! |
Displaying zeroes in decimals
You should see a comma style button on your formatting toolbar. It's next to
the dollar button and the percentage button. Click that and your numbers will be formatted with 2 decimal places. Use th two buttons next to that to increase or decrease the number of decimal places. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "patrickcnj" wrote: I need to display numbers like "1.0" and 2.0" and I can't get around the auto-correct that changes them to "1" and "2". How do I do this? Thanks! |
Displaying zeroes in decimals
You could also use a Number format and specify the number of decimal places you
wanted to see. patrickcnj wrote: I need to display numbers like "1.0" and 2.0" and I can't get around the auto-correct that changes them to "1" and "2". How do I do this? Thanks! -- Dave Peterson |
All times are GMT +1. The time now is 03:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com