Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting numbers with two decimals Leslie W. Excel Worksheet Functions 4 June 1st 07 08:54 PM
Changing whole numbers into decimals Dos_III Excel Worksheet Functions 3 January 24th 07 04:58 AM
How do Multiply whole numbers by decimals help Excel Worksheet Functions 3 September 30th 05 10:21 PM
sort "numbers" with decimals Melissa Excel Discussion (Misc queries) 4 September 2nd 05 02:28 PM
Excel: How can I get numbers without decimals ? Wamalapada New Users to Excel 2 April 9th 05 01:43 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"