Weird Diplay Glitch? Everything divided by 100!

R

robbyg4307

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

After installing Office update 12.1.1 yesterday, I encountered a weird display glitch today on both my MacBook Pro and Mac Pro computers. Upon opening the application and entering 1 into ANY cell, Excel displays .01 instead. Similarly, if I enter 1234 into ANY cell, Excel displays 12.34. I have not applied any formulas, functions or formats to these cells to divide the entered amount by 100. I checked my preference settings and could not find any clues or explanations. I rebuilt my permissions and restarted both computers, yet the problem persists. Both Intel Macs are running Mac OS X 10.5.4. Does anyone have an explanation for what is going on or what settings I should check?

Confused.

Rob
 
C

CyberTaz

Hi rob -

Excel> Preferences> Edit, clear the check for "Display this number of
decimal places".

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Weird DISPLAY Glitch? Everything divided by 100! [updated] 5
Excel 08 divides numbers by 100 2
Numbers are automatically divided by 100 and I can't turn it off 3
Excel divides every number by 100 upon manual data entry 2
Can't open a file - seeing "excel cannot open this file - the file may have been damaged or modified 2
Performance is unusably slow.. 3
weird printing problem 0
Inking Feature for Microsoft Word for Mac 1

Top