numbers & decimals

C

chas.

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.
 
O

OssieMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
How to count the numbers in a Word document? 0
Need Help with a VBA subroutine 0
Merging from an Excel file with graphics 1
Delete all data after a symbol in a field 0
Word macro that can call cells out of Excel for a find and replace 0
Insert Index into a Table 1

Top