Try

ActiveCell.NumberFormat = "@"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"willz99ta via OfficeKB.com" <u6624@uwe> wrote in message
news:5d338f36895bd@uwe...
> Howdy,
>
> I am trying to change the ActiveCell catagory from Number to
> Text. Is there
> a quick way to do this in VBA?
>
> Thanks,
> Will
>
> --
> Message posted via http://www.officekb.com