Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatic division
if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1
Does anybofy know how to fix this? Thanks Bart |
#2
|
|||
|
|||
<Tools <Options <Edit tab,
And *UNCHECK* "Fixed Decimal Places". -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Bart" wrote in message ... if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1 Does anybofy know how to fix this? Thanks Bart |
#3
|
|||
|
|||
Tools-Options-Edit Tab-Uncheck "Fixed Decimal"
-- Regards, Dave "Bart" wrote: if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1 Does anybofy know how to fix this? Thanks Bart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
Enable Automatic Refresh | Excel Worksheet Functions | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
find automatic page breaks | Excel Worksheet Functions | |||
Automatic backup copy | Charts and Charting in Excel |