Set format cells

B

Bob Phillips

Posting on Christmas Day?

Try this

Selection.NumberFormat = "dd-mmm-yyyy"

as an example.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top