ExcelBanter - decimal places

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

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

- - decimal places (https://www.excelbanter.com/excel-programming/294005-decimal-places.html)

keyur

decimal places

hi

how can i get a result with only say 2 decimal places?
i have something like

num = 34* nrows/500/60

i want to display this in a message box with only 2
decimal places.

thanks

Vasant Nanavati

decimal places

MsgBox Format(num, "#.00")

--

Vasant

"keyur" wrote in message
...
hi

how can i get a result with only say 2 decimal places?
i have something like

num = 34* nrows/500/60

i want to display this in a message box with only 2
decimal places.

thanks

keyur

thanks decimal places

thanks a lot
-----Original Message-----
MsgBox Format(num, "#.00")

--

Vasant

"keyur" wrote in
message
...
hi

how can i get a result with only say 2 decimal places?
i have something like

num = 34* nrows/500/60

i want to display this in a message box with only 2
decimal places.

thanks

.

All times are GMT +1. The time now is 04:44 PM.