S shireeshn Member Nov 2, 2008 #1 Irrespective of user setting using com handle, how can I set the currency to ‘$’ always with two decimal places.
Irrespective of user setting using com handle, how can I set the currency to ‘$’ always with two decimal places.
P Picasso New Member Nov 3, 2008 #2 /*This should do as you require*/ /*objRange is your Range com-handle*/ objRange = objSheet:Range(Firstcell , Lastcell). objRange:NumberFormat = "[$$-409]#,##0.00".
/*This should do as you require*/ /*objRange is your Range com-handle*/ objRange = objSheet:Range(Firstcell , Lastcell). objRange:NumberFormat = "[$$-409]#,##0.00".
