Hello all,
I was wondering if someone could help.
I'm working with dates that are formatted as 06/03/2014 (American format, UK location) but I wish to replace the "/" with a "."
The problem is when I do this via my macro Selection.Replace What:="/", Replacement:="." the result is 6.3.2014 but it's essential that the 0's do not get removed.
If I manually find and replace the problem does not occur....
How can I overcome this problem?
Many thanks
Bookmarks