Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I set the default for "show zeroes" to not show the zeroes? | Setting up and Configuration of Excel | |||
Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
Displaying decimals that go in to a given number | Excel Discussion (Misc queries) | |||
No decimals and leading zeroes | Excel Discussion (Misc queries) | |||
CSV leading zeroes | Excel Discussion (Misc queries) |