|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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
|
|
Tools>Options, Edit tab, uncheck Fixed decimal
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"johncassell" <johncassell.2cqkxq_1155905704.4946[ at ]excelforum-nospam.com> wrote in message
news:johncassell.2cqkxq_1155905704.4946[ at ]excelforum-nospam.com...
|
| 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
|
|
|
|
|
|