Solved: Format Cell Question

[CreganTur]

Search isn't working here... google has failed me... so I'll go ahead and post this, even though I know this has already been answered somewhere else. I just wish I could find it!

I'm using "ActiveWorkbook.Worksheets.Add , ActiveSheet" to create a new worksheet(Sheet2), and then I'm moving some data from Sheet1 to the newly created Sheet2. I just need to know how to set the cell formatting to Text on Sheet2- I've got some numbers that have to have text formatting because this process prepares an Excel report's data so it can be Mail Merged into a form letter.

Thanks

[Bob Phillips]

[vba]

myrange.NumberFormat = "@"
[/vba]