Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |