Excel newbie
New Member
- Joined
- Jun 17, 2005
- Messages
- 11
I have a form to enter some custom data into a worksheet. However the data entered into the form is not copied exactly as is onto the worksheet.
This is the code from the form that copied the value into the cell:
ActiveCell.Offset(0, 4).Activate
ActiveCell.Value = mach
mach is a single, the number i entered into the form
But the number I entered into the form is alway slightly off when copied into the cell. For example, if i enter 0.8 into the form, the cell value read 0.80000001. It cause my if statement to return false when I check for mach<=0.8.
How do I fix it so that the value copied is exact?
Thanks in advance
This is the code from the form that copied the value into the cell:
ActiveCell.Offset(0, 4).Activate
ActiveCell.Value = mach
mach is a single, the number i entered into the form
But the number I entered into the form is alway slightly off when copied into the cell. For example, if i enter 0.8 into the form, the cell value read 0.80000001. It cause my if statement to return false when I check for mach<=0.8.
How do I fix it so that the value copied is exact?
Thanks in advance