number format in excel

R

Royal Gala

I have an issue with excel 2003 running on one of my laptop. The integer
number i input in every cell will be divided by 1000, for example when I
input 123 the cell will show 0.123, however if I input 123.00 it will show
just as 123. Also if I copy the excel file to other computers everything
looks ok. There is no cell format defined. It looks like an global setting
in excel because either old excel file or new created excel file all have
the same issue.
Anyone can help?
 
R

Ragdyer

From the Menu Bar:

<Tools> <Options> <Edit> tab,

and *uncheck* "Fixed Decimal Places".
 

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

Found few bugs in my daily routine of work in excel for MAC 0
Excel does not accept text format! 0
Embedded Excel into Word with Tables 0
Word macro that can call cells out of Excel for a find and replace 0
Menu driven PowerPoint presentations 0
Autonumber field in Excel that behaves the same as Access 0
Menu Macro Not Executing - Need Help 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top