Formatting from VBE

[pls123]

Hello all !
I need to format a cell from VBE...
it must formattes as number with 2 decimals..

then i will insert in my work..
help me please !!
byee

 

[aflatoon]

You can set a cell's number format in VBA:


Code:
--------------------


Range("A1").Numberformat = "0.00"
--------------------




for example.

Hello all !
I need to format a cell from VBE...
it must formattes as number with 2 decimals..

then i will insert in my work..
help me please !!
byee

 

[om]

Try

Selection.NumberFormat = "0.00"

 

[Dave Peterson]

A lot of times, it's easiest to record a macro and change the format. Then stop
recording and just steal the code you need.

If I'm gonna do lots of recording, sometimes I'll even start a test workbook and
record in there so that I don't damage anything important.

 

[ozgrid.com]

Record a macro formatting your