Hi Stuart -

It sounds like the Replace function might work for you. Here is a
demonstration procedu

Sub Stuart()
Const dt = "14/03/07"
new_dt = Replace(dt, "/", "")
MsgBox new_dt
End Sub

---
Jay


"Stuart" wrote:

The subject line is exactly what I need,

I do not want the dates to have any characters between them. I just
literally want six digits.

Our system cannot accept character only numberics.

If a macro could do this that would be amazing,

Let me know,

Thanks

Stuart