excel cell formatting

Question

How can I change the cell format to be text in Excel programatically?

Answer 1

You can use:

Range("A1").NumberFormat = "@"

for text

Range("A1").NumberFormat = "dd/mm/yyyy hh:mm:ss" 

for a date.

Range("A1").NumberFormat = "#,###"

for money, etc.

Answer 2

The way that I answer this and other excel queries it to record a macro in Excel, perform the action that I want to see how to do, and then look at the macro to see what it recorded.

Doing that, this questions answer is:

Selection.NumberFormat = "@"