glad to help

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
The trouble was that the cells were in a custom format. I changed the
format to text ("@") and the problem went away. Thanks for all the
help! -Abe


Don Guillett wrote:
Sub insertslash()
With Range("A1")
.NumberFormat = "# ?/?"
.Value = Range("a2") & "/" & Range("b2")
End With
End Sub

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hey--Thanks for the help guys. The syntax you gave works for inserting
characters like 'a' in between the values, but for some reason it is
still dividing when I try to insert the /. Any ideas about what is
going on?

My code, exactly:

Sub test()

[a1] = [a11] & "/" & [a9]

End Sub