How numbers are displayed

C

ctomblin

New Member
Joined
Apr 25, 2002
Messages
49
Excel has started dividing by 100 every number I input. So if I input 2000 I see 20 in the cell. It happens in every cell in every worksheet including new worksheets. If I type 2000.00 I see the correct view, eg 2000, otherwise it's wrong.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
Sounds like you've got fixed decimals turned on.

Go to Tools|Option|Edit tab and see if the box next to fixed decimals is checked.
 
Upvote 0
go to your Excel options, click on the edit tab, and deselect the "fixed decimal" option.

Corticus
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
How to display different values to ones entered
Replies
2
Views
103
kevin9999
K
X
  • Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
274
KRice
K
D
  • Question
FILTER Function Doesn't Display Formatting
Replies
3
Views
86
Fluff
Fluff
J
  • Solved
No formulas working to rename sheets within workbook
Replies
9
Views
158
Joe4
Joe4
C
  • Question
Inserting rows when value's are input into cells
Replies
0
Views
571
cdude911
C

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,093
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top