ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   input in number form is being multiplied by 1000 when i input. (https://www.excelbanter.com/excel-discussion-misc-queries/139127-input-number-form-being-multiplied-1000-when-i-input.html)

jweinograd

input in number form is being multiplied by 1000 when i input.
 
When I input numbers in "number" (not text) form they are all multiplied by
1000. I have no idea what is going on and I really need excel for my school
work.

Thank you,
Joe-

Peo Sjoblom

input in number form is being multiplied by 1000 when i input.
 
Toolsoptionsedit, deselect fixed decimal places

--
Regards,

Peo Sjoblom


"jweinograd" wrote in message
...
When I input numbers in "number" (not text) form they are all multiplied
by
1000. I have no idea what is going on and I really need excel for my
school
work.

Thank you,
Joe-




JE McGimpsey

input in number form is being multiplied by 1000 when i input.
 
In Tools/Options/Edit, Uncheck the Fixed decimal places checkbox.

In article ,
jweinograd wrote:

When I input numbers in "number" (not text) form they are all multiplied by
1000. I have no idea what is going on and I really need excel for my school
work.

Thank you,
Joe-


Toppers

input in number form is being multiplied by 1000 when i input.
 
Tools=Options=Edit=Uncheck 'Fixed decimal places '(set as -3?)

"jweinograd" wrote:

When I input numbers in "number" (not text) form they are all multiplied by
1000. I have no idea what is going on and I really need excel for my school
work.

Thank you,
Joe-


jweinograd

input in number form is being multiplied by 1000 when i input.
 
Thank you all very much. This fixed my problem.

Thank you again,
Joe-


All times are GMT +1. The time now is 10:41 PM.

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