Thread: Setting range of cells format to currency
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Setting range of cells format to currency
Range("A1:B200").Numberformat = "$ #,##0.00"

--
Regards,
Tom Ogilvy


Radek Michalski wrote in message
...
Hi!

Can You tell me how should I use VB to change format for a range of cells
in
Excel from numeric to currency?

Range(a,b) . what's_next :) ? (or maybe I'm going in wrong direction?)

Greetings
Radek




Reply With QuoteReply With Quote