Decimal place formatting gone wrong!!

[Shirley]

We are running Excel 2003 (XP Business)
I have a work sheet which looks like following:

A B C
2356 5.50 4.50

Having returned from holiday (every body swears they hav'nt touched program)
I now find that I am getting all figures rounded up and decimal places are
not correct as following when I enter the same figures from above I get

A B C
24 0.55 0.45

I have gone into format and reformatted to 0 decimal places (A) and 2
decimal places for B & C without any luck.
No matter what I try I still get the above, it always puts a decimal point
in regardles of what number I enter.
There are no formulas in any of the cells.

Any ideas what has gone wrong and how can I cure the problem

Shirley
--

 

[Guest]

Hi

Have a look at Tools / Option / Edit / Fixed decimals. That might be the
cause.

 

[David McRitchie]

Hi Shirley,
If that is the problem, would you look at your 2003 Excel Help
to see if topic "Enter numbers with decimal places or trailing zeros"
still ends with...

Tip To temporarily override the Fixed decimal option, type
a decimal point when you enter the number.

The first is being adjusted by 2 decimal places and the other
two are being adjusted by 1 decimal place even though you
entered the decimal point.

Would you also right click on the sheet tab, view code and see
if you have an Event macro, because that sounds more like
something that could cause that many inconsistencies.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi

Have a look at Tools / Option / Edit / Fixed decimals. That might be the
cause.

 

[Shirley]

David
You will see that advice from Andy did the trick and cured problem.

However we have a problem with another workbook which has been giving us
grief!!
On your advice I checked and found an Event macro running. This was causing
the problem - this has now been sorted.
Many thanks

Shirley

Hi Shirley,
If that is the problem, would you look at your 2003 Excel Help
to see if topic "Enter numbers with decimal places or trailing zeros"
still ends with...

Tip To temporarily override the Fixed decimal option, type
a decimal point when you enter the number.

The first is being adjusted by 2 decimal places and the other
two are being adjusted by 1 decimal place even though you
entered the decimal point.

Would you also right click on the sheet tab, view code and see
if you have an Event macro, because that sounds more like
something that could cause that many inconsistencies.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Shirley]

Andy
Yes it worked - Fixed decimals were set at 2.

Very many thanks to you for solving propblem.

Shirley

Hi

Have a look at Tools / Option / Edit / Fixed decimals. That might be the
cause.

 

[David McRitchie]

Hi Shirley,
Are you positive that if you entered 5.50 that you got .55
because that is not the way fixed decimals should work.
Because you typed the decimal point it should be unchanged
no matter how many fixed decimal places you asked for.

Help comes in mysterious ways, glad you solved all your
problems. But hopefully something was left out here in
the question.

David