Mike,
I would think the difference is minimal.


"Mike" wrote:

Thanks for that that's just what I needed.

Is it faster if I am formatting say 200 rows of data to format the whole
column or to use the Rows.Count and only format the rows with data i them??


Thanks
Mike


"Toppers" wrote:

Mike,

Range("H:H,K:K,G13:G" & Rows.Count).NumberFormat = "0.000"

Format with 3 decimal places


HTH

"Mike" wrote:

I need to format a number to for decimal in all of column H and K and only
G13 to the end of the G column how do I do this?

Mike