Help with .NumberFormat

Can you please explain or provide a link to info about the .NumberFormat parameter?

I am using:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

but I also need to set a cell to "text" (in Excel, the command is Format, Cells, Number, Text)

and another cell to 3 decimal places ...

Thanks for helping me.

For text

Please Login or Register  to view this content.

For Decimals

Please Login or Register  to view this content.

if in doubt - use the macro recorder and review...

Hi,

Please Login or Register  to view this content.

Rgds