Display feet inches and fraction
See inline comments...
When I add the following ........)-1)+((-1)*(MID...... the formula
works.
It was subtracting the fraction from the whole number.
I'm glad you got it sorted out.
Two things I have encountered and cannot find the solution is in the VBA.
If I put text into a cell and erase the text or clear contents, an inch
mark
is left. This cannot be removed unless I am in design mode.
Can you give us an example? Show us what is in the cell and the code you are
using to erase or clear it.
When I try to copy one cell to another I get a popup with Run-time error
'13': Type mismatch. When I click on Debug the line that is highlighted
is
TargetPattern = Target.Value.
Can you show us your code?
Rick
|