On Sunday, March 10, 2013 1:52:55 PM UTC-5, Claus Busch wrote:
Hi Wes,



Am Sun, 10 Mar 2013 11:42:53 -0700 (PDT) schrieb Wes Finch:



I did not test it hard enough. In some instances it is still reverting to a date.



try:

.Range("D" & i).NumberFormat = "@"

.Range("D" & i) = .Range("B" & i) & "/" & .Range("C" & i)





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Thanks Claus,
But no that does not work either.
Wes