format as general not as number
the macro instruction would be
Range("A12").Select
Selection.NumberFormat = "General
--
bill
-----------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...info&userid=82
View this thread:
http://www.excelforum.com/showthread.php?threadid=47889