After a recent upgrade I'm having an issue with cells that are formatted as
numbers with 0 decimal places. If I key in a number of 4778 when I exit the
cell it formats it as 48, rounding the remainder. This just began last week,
previous worsheets appear ok until you retype the numbers in those cells.
I'm using Office 2003, SP3.

Thanks

Tools/Options/Edit/Deselect "Fixed Decimal Places"

"Lou" wrote in message
...
After a recent upgrade I'm having an issue with cells that are formatted
as
numbers with 0 decimal places. If I key in a number of 4778 when I exit
the
cell it formats it as 48, rounding the remainder. This just began last
week,
previous worsheets appear ok until you retype the numbers in those cells.
I'm using Office 2003, SP3.

Thanks

Thanks!

"Bob Umlas" wrote:

Tools/Options/Edit/Deselect "Fixed Decimal Places"

"Lou" wrote in message
...
After a recent upgrade I'm having an issue with cells that are formatted
as
numbers with 0 decimal places. If I key in a number of 4778 when I exit
the
cell it formats it as 48, rounding the remainder. This just began last
week,
previous worsheets appear ok until you retype the numbers in those cells.
I'm using Office 2003, SP3.

Thanks