Why are my number entries multiplied by 1000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a workbook that I have been using succesfully for three
years, several times per year. Now, after I enter a number into a cell
formatted for "General," "Number," "Currency," or "Accounting," that entry is
multiplied by 1000 when I tab out of the cell. This applies to all sheets of
the workbook, including those made previously. The only thing that I have
done since last using the workbook has been to rename it on the floppy that I
was storing it on. What's the cause, please? [Now being used on Excel 2002,
but was created on Excel 97, and used in the interim on Excel 2000; macros
are disabled (none of which involved multiplication anyway)]
 
Tools|Options|Edit and either uncheck "Fixed decimal Places".

It is unclear how this is making Excel crash (the topic of this newsgroup).

Jerry
 
Jerry--
That did it; thanks!
FS volunteer

P.S. Although I now notice that "...excel. crashes..." is part of this
group's URL, the "Excel" dropdown list on Microsoft's Office Discussion
Groups homepage lists it merely as "Application Errors." I interpreted this
to mean situations in which Excel was executing unexpected or wrong actions;
in perusing the posts herein, it would appear I'm not the only one making
that interpretation. If you want the group limited to full-scale crashes, I
suggest you ask Microsoft to change their homepage. Meanwhile, thanks again.

Jerry W. Lewis said:
Tools|Options|Edit and either uncheck "Fixed decimal Places".

It is unclear how this is making Excel crash (the topic of this newsgroup).

Jerry

FS said:
I am working with a workbook that I have been using succesfully for three
years, several times per year. Now, after I enter a number into a cell
formatted for "General," "Number," "Currency," or "Accounting," that entry is
multiplied by 1000 when I tab out of the cell. This applies to all sheets of
the workbook, including those made previously. The only thing that I have
done since last using the workbook has been to rename it on the floppy that I
was storing it on. What's the cause, please? [Now being used on Excel 2002,
but was created on Excel 97, and used in the interim on Excel 2000; macros
are disabled (none of which involved multiplication anyway)]
Click to expand...
Click to expand...
 
Jerry--

I inadvertently rated your post as NOT answering my question, having
initially read your menu instructions ("Tools/Options...") as a header. I've
searched unsuccesfully for a way to correct this myself, but have noted that
an MVP can rate a post positively. Since your post clearly did answer the
question, and solve my problem, please ask an MVP to intervene, or tell me
how I can switch my rating.

Sorry, and thanks.

Jerry W. Lewis said:
Tools|Options|Edit and either uncheck "Fixed decimal Places".

It is unclear how this is making Excel crash (the topic of this newsgroup).

Jerry

FS said:
I am working with a workbook that I have been using succesfully for three
years, several times per year. Now, after I enter a number into a cell
formatted for "General," "Number," "Currency," or "Accounting," that entry is
multiplied by 1000 when I tab out of the cell. This applies to all sheets of
the workbook, including those made previously. The only thing that I have
done since last using the workbook has been to rename it on the floppy that I
was storing it on. What's the cause, please? [Now being used on Excel 2002,
but was created on Excel 97, and used in the interim on Excel 2000; macros
are disabled (none of which involved multiplication anyway)]
Click to expand...
Click to expand...
 
FS said:
Jerry--
That did it; thanks!
FS volunteer
Click to expand...


You're welcome, Glad it helped.

P.S. Although I now notice that "...excel. crashes..." is part of this
group's URL, the "Excel" dropdown list on Microsoft's Office Discussion
Groups homepage lists it merely as "Application Errors." I interpreted this
to mean situations in which Excel was executing unexpected or wrong actions;
in perusing the posts herein, it would appear I'm not the only one making
that interpretation. If you want the group limited to full-scale crashes, I
suggest you ask Microsoft to change their homepage. Meanwhile, thanks again.
Click to expand...


I agree that MS's characterization of this group in that interface is
easily misinterpreted.

Jerry
(Excel MVP)
 
Back
Top