Help with .NumberFormat

[proepert]

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

I am using:

.NumberFormat = "General"

and

.NumberFormat = "0"

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.

[DonkeyOte]

For text

.NumberFormat = "@"

For Decimals

.NumberFormat = "0.000"

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

[proepert]

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

Thanks, this will reduce me post count and I can learn myself.

[Richard Buttrey]

Hi,

for text:
.NumberFormat = "@"

3 dec pl:
.NumberFormat = "#.000"

Rgds

[proepert]

Thanks to all, you are all so very helpful.