Change excel cell datatype! 1

[wendywam]

Hi
I have a number like this: 08312345678
When I enter that number in excel cell, the zero is removed.
I can format the excel cell not to discard the zero using the Excel application.
I want to do the same thing programatically with visual basic.
How do I do that?
If I want to format a cell to general type, I do this
range.numberformat = "General"
How do you do the same with Text type?

 

[RoyVidar]

When using the macro recorder, it gives:
[tt]selection.numberformat = "@"[/tt]

I often keep banging my head against tha wall for a while, until I remember the recorder;-)

Roy-Vidar