ExcelBanter - Setting range of cells format to currency

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Setting range of cells format to currency (https://www.excelbanter.com/excel-programming/285936-setting-range-cells-format-currency.html)

Radek Michalski

Setting range of cells format to currency

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

Tom Ogilvy

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

All times are GMT +1. The time now is 08:52 PM.