values always multiplied by 100

  • Thread starter Thread starter Colin Scarret
  • Start date Start date
C

Colin Scarret

Excel 97.
When I enter an integer value in a cell, it is
automatically multiplied by 100 e.g. entering 3 will
result in the cell having the value 300. The cell is also
multiplied by 100, each and every time it becomes the
active cell. If I include a decimal point in the input
e.g. 3. or 3.1 the cell value remains as input.
 
Hi Colin!

Use:
Tools > Options > Edit
Remove check from "Fixed decimal places"
OK

You currently have this set at -2

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

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

Paste Special Formula Multiply feature doesn't work anymore 2
how do i create a percantage formula in a cell? 2
Time multiplied by cost per hr 2
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% 10
Roundup with paste special 3
how do I change format to percentage without multiplying by 100 5
same cell multiplied by set value 1
Can RGB fill color be automated based on 3 cell values? 2

Back
Top