Custom Format- Feet & Inch

[bamaisgreat]

I was wandering if it was possible to have a cell that when you entered 240 and hit enter it would show 240 (20')?
I was hoping this would be possible with the custom option in the format cells dialog. Thanks for the Help.

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the target range (in red) to suit your needs. Close the code window to return to your sheet. Enter a value in column A and press the RETRUN key.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("[COLOR="#FF0000"]A:A[/COLOR]")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    Target = Target & " (" & Target / 12 & "')"
    Application.EnableEvents = True
End Sub