ExcelBanter - variable as Currency two decimal places

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

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

- - variable as Currency two decimal places (https://www.excelbanter.com/excel-programming/297863-variable-currency-two-decimal-places.html)

Max Bialystock

variable as Currency two decimal places

Hi,

I've defined a variable as Currency. Can I have it display with only two
decimal places. This variable is not in a cell.

--
Regards,
David Lindstrom

Bob Phillips[_6_]

variable as Currency two decimal places

If you format it

Format(myVar,"#,##0.00")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Max Bialystock" wrote in message
...
Hi,

I've defined a variable as Currency. Can I have it display with only two
decimal places. This variable is not in a cell.

--
Regards,
David Lindstrom

Max Bialystock

variable as Currency two decimal places

Fantastic!

Thanks for your help, Bob, I really appreciate it.

--
Regards,
David Lindstrom

"Bob Phillips" wrote in message
...
If you format it

Format(myVar,"#,##0.00")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Max Bialystock" wrote in message
...
Hi,

I've defined a variable as Currency. Can I have it display with only two
decimal places. This variable is not in a cell.

--
Regards,
David Lindstrom

All times are GMT +1. The time now is 12:29 PM.