ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Displaying zeroes in decimals (https://www.excelbanter.com/excel-discussion-misc-queries/195534-displaying-zeroes-decimals.html)

patrickcnj

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!

M Kan

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!


Dave Peterson

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