ExcelBanter - Need Number style

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need Number style (https://www.excelbanter.com/excel-programming/355595-need-number-style.html)

Metrazal[_40_]

Need Number style

How do I get the Number style. I tried:

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

Cells(lastrw, "P").Style = "Number"

--------------------

Thanks,

Met

--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=520689

Jim Thomlinson

Need Number style

Are you looking to format the number???

Cells(lastrw, "P").numberformat = "#,##0.00"
--
HTH...

Jim Thomlinson

"Metrazal" wrote:

How do I get the Number style. I tried:

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

Cells(lastrw, "P").Style = "Number"

--------------------

Thanks,

Met

--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=520689

Metrazal[_41_]

Need Number style

Yes.. Format will work..

Thanks..

--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=520689

All times are GMT +1. The time now is 12:18 AM.