Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically changing my numerical entry- when I don't want it to
When I enter a number excel is multiplying it by 100. I've tried messing
with Format, Cells, Number but that doesn't help. I've also tried tools, options, edit and unchecking the fixed decimal places... Help please! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically changing my numerical entry- when I don't want it to
Toolsoptionsedit clear the check mark in fixed decimal places
-- Regards, Peo Sjoblom "Christina08" wrote in message ... When I enter a number excel is multiplying it by 100. I've tried messing with Format, Cells, Number but that doesn't help. I've also tried tools, options, edit and unchecking the fixed decimal places... Help please! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically changing my numerical entry- when I don't want it to
One sheet? All sheets? One workbook? All workbooks?
Since you state you do not have "fixed decimals" checked I can only suggest some type of event code. Have a look through whatever workbook or sheet you're having the problem with. Gord Dibben MS Excel MVP On Tue, 19 Aug 2008 08:50:01 -0700, Christina08 wrote: When I enter a number excel is multiplying it by 100. I've tried messing with Format, Cells, Number but that doesn't help. I've also tried tools, options, edit and unchecking the fixed decimal places... Help please! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I assign a numerical value to a textual entry to calculate percent completion? | Excel Worksheet Functions | |||
Changing Y-Axis Labels from Numerical to Textual | Charts and Charting in Excel | |||
How do I stop Excel from converting a numerical entry to a date? | Excel Discussion (Misc queries) | |||
Date entry automatically | Excel Discussion (Misc queries) | |||
Changing an entry from another worksheet | Excel Discussion (Misc queries) |