Format as text (Excel 2002 sp3)

Topic

New Reply

I need to format cells as text so that number retain their leading zeros. If I do so from the menu, I get the results I want. However, I cannot see how to do this via code.

Reply | Quote

Replies

The following will format column A to Text:


Range("A:A").NumberFormat = "@"


Reply | Quote

Thanks. I tried that, it did not work. I read your post so I tried it again. It helps if I type in the correct column number! Now I feel silly.

Thanks again.

Reply | Quote