View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default New issue with cell formatting

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