C
ChrisMattock
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?
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?