ExcelBanter - how to define decimal places in macro?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to define decimal places in macro? (https://www.excelbanter.com/excel-discussion-misc-queries/224730-how-define-decimal-places-macro.html)

Oligo

how to define decimal places in macro?

how do i define the cell A2:E20 to have 2 decimal placing??

FSt1

how to define decimal places in macro?

hi
try....
range("A2:E20").NumberFormat = "0.00"

regards
FSt1

"Oligo" wrote:

how do i define the cell A2:E20 to have 2 decimal placing??

Shane Devenshire

how to define decimal places in macro?

Hi,

Try

[A2:E20].NumberFormat ="0.00"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Oligo" wrote:

how do i define the cell A2:E20 to have 2 decimal placing??

Bob Flanagan[_3_]

how to define decimal places in macro?

Range("a2:e20").numberformat ="0.00"

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Oligo" wrote in message
...
how do i define the cell A2:E20 to have 2 decimal placing??

All times are GMT +1. The time now is 07:21 AM.