numberFormat

[destatnj2]

Hi All,

Try this: Right click on a cell, select "Format Cells..." go to the
"Number" tab and select "Number"...

Then write a function where you select that particular cell and then say:

Range("ParticularCell").Select
ActiveCell.NumberFormat = "@"

to explicity change the cell format from "Number" to "Text". If you run the
function and then go back to that cell on the sheet, right click and check
the "Format Cells..." properties, you will find that the cell is still
"Number" and not "Text" format. Am I doing this the wrong way?

Thanks,

Pete

 

[destatnj2]

Please disregard the previous post. I found the solution, thanks.

 

[Toby Erkson]

What was the solution?