software

My Excel 2003 spreadsheet is all of sudden automatically converting any
numbers I enter by what appears to be dividing by 1000. I checked the
autocorrect function but that does not appear to be the problem, is there
another way Excel pre-processes date entered?

Thanks


quot;Alicequot; gt; wrote in message
...
gt; My Excel 2003 spreadsheet is all of sudden automatically converting any
gt; numbers I enter by what appears to be dividing by 1000. I checked the
gt; autocorrect function but that does not appear to be the problem, is there
gt; another way Excel pre-processes date entered?
gt;
gt; Thanks

Take a peek at the formatting for one of the cells and see if something
odd's going on in the number format.
Hi Alice

If you click on Tools, Options and select the Edit tab, you will most likely
see that fixed decimal places have been ticked, and with 3 decimal places.
Untick and you should be OK.
hth

quot;Alicequot; wrote:

gt; My Excel 2003 spreadsheet is all of sudden automatically converting any
gt; numbers I enter by what appears to be dividing by 1000. I checked the
gt; autocorrect function but that does not appear to be the problem, is there
gt; another way Excel pre-processes date entered?
gt;
gt; Thanks

Thanks. That was it! My mother thanks you too! :-)

Any idea how that setting would have been set, since the spreadsheets I had
did not have that problem before so it somehow was changed?
quot;Kassiequot; wrote:

gt; Hi Alice
gt;
gt; If you click on Tools, Options and select the Edit tab, you will most likely
gt; see that fixed decimal places have been ticked, and with 3 decimal places.
gt; Untick and you should be OK.
gt; hth
gt;
gt; quot;Alicequot; wrote:
gt;
gt; gt; My Excel 2003 spreadsheet is all of sudden automatically converting any
gt; gt; numbers I enter by what appears to be dividing by 1000. I checked the
gt; gt; autocorrect function but that does not appear to be the problem, is there
gt; gt; another way Excel pre-processes date entered?
gt; gt;
gt; gt; Thanks

quot;Alicequot; gt; wrote in message
...
gt; Thanks. That was it! My mother thanks you too! :-)
gt;
gt; Any idea how that setting would have been set, since the spreadsheets I
gt; had
gt; did not have that problem before so it somehow was changed?

Ask around the house. Someone will say they didn't touch any of those
options. That's the person who did it. Always. No exceptions. Guilty. :-)
This option (fixed decimal), *as well as* the (manual - auto) calculate
option are determined per session, by the saved option of the *first* file
opened in that session.

See if this old post explains it to you:

tinyurl.com/anahg

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Alicequot; gt; wrote in message
...
gt; Thanks. That was it! My mother thanks you too! :-)
gt;
gt; Any idea how that setting would have been set, since the spreadsheets I
had
gt; did not have that problem before so it somehow was changed?
gt;
gt;
gt;
gt; quot;Kassiequot; wrote:
gt;
gt; gt; Hi Alice
gt; gt;
gt; gt; If you click on Tools, Options and select the Edit tab, you will most
likely
gt; gt; see that fixed decimal places have been ticked, and with 3 decimal
places.
gt; gt; Untick and you should be OK.
gt; gt; hth
gt; gt;
gt; gt; quot;Alicequot; wrote:
gt; gt;
gt; gt; gt; My Excel 2003 spreadsheet is all of sudden automatically converting
any
gt; gt; gt; numbers I enter by what appears to be dividing by 1000. I checked the
gt; gt; gt; autocorrect function but that does not appear to be the problem, is
there
gt; gt; gt; another way Excel pre-processes date entered?
gt; gt; gt;
gt; gt; gt; ThanksThanks for the reference it was helpful.quot;RagDyerquot; wrote:

gt; This option (fixed decimal), *as well as* the (manual - auto) calculate
gt; option are determined per session, by the saved option of the *first* file
gt; opened in that session.
gt;
gt; See if this old post explains it to you:
gt;
gt; tinyurl.com/anahg
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt; ==============================================
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ==============================================
gt;
gt;
gt; quot;Alicequot; gt; wrote in message
gt; ...
gt; gt; Thanks. That was it! My mother thanks you too! :-)
gt; gt;
gt; gt; Any idea how that setting would have been set, since the spreadsheets I
gt; had
gt; gt; did not have that problem before so it somehow was changed?
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Kassiequot; wrote:
gt; gt;
gt; gt; gt; Hi Alice
gt; gt; gt;
gt; gt; gt; If you click on Tools, Options and select the Edit tab, you will most
gt; likely
gt; gt; gt; see that fixed decimal places have been ticked, and with 3 decimal
gt; places.
gt; gt; gt; Untick and you should be OK.
gt; gt; gt; hth
gt; gt; gt;
gt; gt; gt; quot;Alicequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; My Excel 2003 spreadsheet is all of sudden automatically converting
gt; any
gt; gt; gt; gt; numbers I enter by what appears to be dividing by 1000. I checked the
gt; gt; gt; gt; autocorrect function but that does not appear to be the problem, is
gt; there
gt; gt; gt; gt; another way Excel pre-processes date entered?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt;
gt;