formatting problem?

B

Benzo

New Member
Joined
Jun 24, 2002
Messages
8
I have Excel 2002+SP3.

When I write for ex 900 to a cell, Excel changes it into 0.09 or if I write 2 it is changed into 0,0002.

What's wrong....
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
Under Tools > Options > Edit, check that Fixed Decimal Places isn't selected. Looks like it is, and it is set to 5...

That causes Excel to automatically divide your input by the # of decimals.

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

Similar threads

P
  • Solved
Dynamic Formula to reference sheets
Replies
2
Views
252
Fluff
Fluff
S
  • Solved
If(and Statement in Conditional formatting
Replies
6
Views
339
smalik
S
N
  • Question
Cell color changes depending on another cell value
Replies
1
Views
137
Peter_SSs
Peter_SSs
E
  • Question
hyperlinks path changes without notice in a excel workbook
Replies
3
Views
226
jkpieterse
jkpieterse
B
  • Question
Number format with 6 digits from import without leading zeros
Replies
4
Views
520
bkeebaugh
B

Forum statistics

Threads
1,214,952
Messages
6,122,454
Members
449,083
Latest member
Ava19

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