Format Currency problem

[cassidybklyn]

Gentlemen, please bear with me:
I am having a problem farmating one column("D"), whose value is currency. I am using this code which I got from recording a macro:
Selection.NumberFormat = "$#,##0.00;[Red]$#,##0.00" Columns("D").select.

Using the above code, all numbers in the spreadsheet conversts to currency, but my objective is to make the the values in only column "D" currency.
Please help.
Thanks.
Cassidy.

 

[PHV]

What about this ?
Columns("D").NumberFormat = "$#,##0.00;[Red]$#,##0.00"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RonRepp]

Columns("D").Select
Selection.NumberFormat = "$#,##0.00;[Red]$#,##0.00"

I hope this helps


Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[AnotherHiggins]

Ron: Why select? Wouldn't PH's suggestion (the same thing without selecting first) be more efficient?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.