View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Zone Zone is offline
external usenet poster
 
Posts: 269
Default The syntax for programmatically inserting a "/" in the middle of a concatenated cell

The code works fine for me. I cannot see how the two numbers are being
divided unless A1 begins with =. Check A1 and make sure it doesn't
begin with =. Then post back. Maybe Don has an idea. James

wrote:
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