Formatting from VBE
 

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

Formatting from VBE
 

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


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


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




for example.


pls123;696870 Wrote:

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

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: 1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194853

http://www.thecodecage.com/forumz

Formatting from VBE
 

Try

Selection.NumberFormat = "0.00"


"pls123" wrote:

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

Formatting from VBE
 

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.

pls123 wrote:

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

--

Dave Peterson

Formatting from VBE
 

Record a macro formatting your
--
Regards
Dave Hawley
www.ozgrid.com selection.



"pls123" wrote in message
...
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