Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
numbers & decimals
In Excel spreadsheet 2007, I have a column I want to enter figures like these:
5.00 4.90 5.25 etc. I enter the figure, leave the cell and it goes to 0 or to 500, or to4.9. I can't keep in there what I want. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
numbers & decimals
Select the cells required and on the Home ribbon, click on the little arrow
bottom right of Number block (about middle of ribbon), select number then set the number of decimal places to display. Regards, OssieMac "chas." wrote: In Excel spreadsheet 2007, I have a column I want to enter figures like these: 5.00 4.90 5.25 etc. I enter the figure, leave the cell and it goes to 0 or to 500, or to4.9. I can't keep in there what I want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting numbers with two decimals | Excel Worksheet Functions | |||
Changing whole numbers into decimals | Excel Worksheet Functions | |||
How do Multiply whole numbers by decimals | Excel Worksheet Functions | |||
sort "numbers" with decimals | Excel Discussion (Misc queries) | |||
Excel: How can I get numbers without decimals ? | New Users to Excel |