![]() |
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- |
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- |
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- |
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- |
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