View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
LOU LOU is offline
external usenet poster
 
Posts: 40
Default New issue with cell formatting

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