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

Data exported to excel 2007 changes cell number format to 'general' ? 1
Default number format in Excel 1
Exported data to Excel 2007 has spaces between rows 1
dang cell format 4
Number entries are automatically divided by 100 - Excel 2003 1
adding 1000 excel files 5
Format Questions 4
::: Telephone Number Comparison or Data Integrity 2

Top