Format Cell Problem

[Robert11]

Hi,

Sorry for all these dumb questions, but I never had any problems with Excel
97.

This one is apparently just too complicated for me at my old age.

Anyway, thanks for all the help; really appreciate it.

So, using Excel 2007, and XP

I select a cell that has a number in it with 5 decimal places.
I go to Format Cells, and select Number, and tell it to go to 4 decimal
places.

It won't, and continues to show 5 decimal places.

This is also true if I try it on a column of numbers.

What am I not doing right ?
(I am sure that what appears in the cell is truly a number, and not text.)

Thanks,
Bob

 

[Gord Dibben]

Why are you sure the number is not text?

In an adjacent cell enter =ISNUMBER(cell)

You get TRUE or FALSE?


Gord Dibben MS Excel MVP

 

[Sheeloo]

There is one way to test
If your number is in A1 then enter this in B1
=ISNUMBER(A1)
If you get FALSE then A1 does NOT contain a number hence the problem...

Check for a ' in the cell (in EDIT mode - press F2 to get into edit mode) or
extra space before/after the number...

in Excel 2007 in the HOME ribbon there is a dropdown which shows the current
formatting..

You will also see a button (they were there in 2003 too) with ->0.00
Click on it to reduce the no. of digits after the decimal...

Failing everything send the file to me...

 

[Robert11]

Hi,

Gosh, am I embarrassed.
It was text after all.

Sure is a lot to learn.

Sorry.

As always, much thanks,
Bob