I have a download that is putting some dates in with a leading space (where
it is a single digit date). I then need to use the networkdays formula on
this, but as there is a leading space it does not register this as a date. If
I manually edit replace the space with a zero this works fine, but if I use a
macro it causes problems - whether I use the edit - replace, or if I
substitute the first character using some other bit of code.
The problem I have is for dates like 7/06/2005 (7th June 2005). If I edit -
replace manually this become 07/06/2005, which is what I want. If I use some
code on this, it then become 06/07/2005 - which when using networkdays with
todays date it is giving me a negative number as this is in the future!
Can anyone give me some code to replace the leading space with a zero and
keep the correct formatting?

Cheers,
cdb