View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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