ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data don't enter correctly in Excel 2002 running under Vista (https://www.excelbanter.com/excel-discussion-misc-queries/169199-data-dont-enter-correctly-excel-2002-running-under-vista.html)

Conrad

Data don't enter correctly in Excel 2002 running under Vista
 
I recently switched from Windows XP to Vista Home Premium (new computer).
Since then, I find that data entered into Excel 2002 always show up as being
ten times smaller than what I entered, forcing me to multiply all data by 10
before entering. Is there a solution to this?

Mike Rogers[_2_]

Data don't enter correctly in Excel 2002 running under Vista
 
Conrad

You might check your "fixed decimal" setting at: ToolsOptionsEdit. Un
check it and see if that helps.

HTH

Mike Rogers

"Conrad" wrote:

I recently switched from Windows XP to Vista Home Premium (new computer).
Since then, I find that data entered into Excel 2002 always show up as being
ten times smaller than what I entered, forcing me to multiply all data by 10
before entering. Is there a solution to this?


Conrad

Data don't enter correctly in Excel 2002 running under Vista
 
That did it. Thanks, Mike.

"Mike Rogers" wrote:

Conrad

You might check your "fixed decimal" setting at: ToolsOptionsEdit. Un
check it and see if that helps.

HTH

Mike Rogers

"Conrad" wrote:

I recently switched from Windows XP to Vista Home Premium (new computer).
Since then, I find that data entered into Excel 2002 always show up as being
ten times smaller than what I entered, forcing me to multiply all data by 10
before entering. Is there a solution to this?


Mike Rogers[_2_]

Data don't enter correctly in Excel 2002 running under Vista
 
Conrad

Glad to help!!!

Mike Rogers

"Conrad" wrote:

That did it. Thanks, Mike.

"Mike Rogers" wrote:

Conrad

You might check your "fixed decimal" setting at: ToolsOptionsEdit. Un
check it and see if that helps.

HTH

Mike Rogers

"Conrad" wrote:

I recently switched from Windows XP to Vista Home Premium (new computer).
Since then, I find that data entered into Excel 2002 always show up as being
ten times smaller than what I entered, forcing me to multiply all data by 10
before entering. Is there a solution to this?



All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com