View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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.