Show 3 or 4 decimals place


#1

Hi,

Is there anyway I could show 3 and 4 decimal place in the cells? actually, the formats I would like to use are #,##0.000 and #,##0.0000

I have looked at the style.number, but none of them seems to be right one.

Please advise,

Kimmomo


#2

Dear Kim,

Thanks for your consideration.

You can use Style.Custom to set custom number format. For exampe,

style.Custom = “#,##0.000”;