Problem entering numbers

  • Thread starter Thread starter johncassell
  • Start date Start date
J

johncassell

Hello, I am having an awkward problem, on every sheet I use(Including
new ones)..

When I enter 100 it changes it to 1.
When I enter 1000 it changes it to 10
When I enter 10000 it changes it to 100.

I thought it was something to do with iteration in the tools>options
menu but I have set both of them to 1 and they are unticked anyway and
it shows the same problem.

Can anyone help please?!?!?

Thanks in advance

John
 
Tools>Options, Edit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hello, I am having an awkward problem, on every sheet I use(Including
| new ones)..
|
| When I enter 100 it changes it to 1.
| When I enter 1000 it changes it to 10
| When I enter 10000 it changes it to 100.
|
| I thought it was something to do with iteration in the tools>options
| menu but I have set both of them to 1 and they are unticked anyway and
| it shows the same problem.
|
| Can anyone help please?!?!?
|
| Thanks in advance
|
| John
|
|
| --
| johncassell
| ------------------------------------------------------------------------
| johncassell's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25016
| View this thread: http://www.excelforum.com/showthread.php?threadid=573031
|
 
Thanks very much for the Niek,

Why I never thought of that I'll never know!!

Thanks again

Joh
 
Back
Top