New issue with cell formatting

L

Lou

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Issue with "Average" showing in Status Bar 2
Formatting Columns in Pivot Tables 5
Excel 2007 Conditional formatting with number formats 3
Cell displays #'s incorrectly 3
How can I fill a block of 300 cells with non-repeating random #s 2
Can't sum a series of numbers 10
blank spaces in front of a number prevents formatting cell 2
Problem with Rounding (2007) 4

Top