what is the syntax for formatting a number as text?

[casen]

hello, my job requires that all fields in the sheet are formatted as text....sometimes the right click command doesnt work properly...i was wondering if there was a way to code it and make it more absolute.

thanks,

casen

 

[erik.van.geit]

Hello, casen
Welcome to the Board !!!!!

yes you can use code
to find this you can use your best friend to genereta the syntax: the MACRO RECORDER
would this do ?
Selection.NumberFormat = "@"
or
Cells.NumberFormat = "@"

kind regards,
Erik