Todd,

For example, to only change rows 3 to 10 within your range:

Intersect(Range("3:10"), Range("P:P,N:N,L:L,J:J,G:G")).NumberFormat = "#,##0.0_);(#,##0.0)"

--
HTH,
Bernie
MS Excel MVP


"ToddS" wrote in message
...
I am a novice macro writer and need help with the following. Here is a piece
of a macro I recorded:

Range("P:P,N:N,L:L,J:J,G:G").Select
Selection.NumberFormat = "#,##0.0_);(#,##0.0)"

The end result I am shooting for is to change the number format as described
above but only for certain cells within the columns I have named in the first
line. Can I modify that line to include the names of these cells or is it
more complicated than this? Help!