Hi all, I have a cell that NEEDS to be of the following format:
0#### ######
I have set this up under formatting, custom... and when I type a number like this...
01304999999 I get the result 01304 999999 PERFECT!
Unfortunately if I type this....
01304 999 999 I get this result 01304 999 999 which ain't good as it mucks up my Macro, whih incidentally is this...
appWD.ActiveDocument.Bookmarks("PMTelephone").Range = Format(strPMTelephone, "0#### ######")
Any ideas?
Bookmarks