New issue with cell formatting
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 |
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 |
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 |
All times are GMT +1. The time now is 06:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com