NumberFormat in Excel

  • Thread starter Thread starter MaTe
  • Start date Start date
M

MaTe

hi,

I have tried to automate excel (2007) in vb.net and i have problem
with function NumberFormat.
I want set the thousand separator for range:
Range("C1:C6").NumberFormat = "0,0.00"
and it pops up an error msg like: can't set property NumberFormat for
Range

Does anyone know the solution??

thanks in advance.
MaTe
 
hi,

I have tried to automate excel (2007) in vb.net and i have problem
with function NumberFormat.
I want set the thousand separator for range:
   Range("C1:C6").NumberFormat = "0,0.00"
and it pops up an error msg like: can't set property NumberFormat for
Range

Does anyone know the solution??

thanks in advance.
 MaTe
Click to expand...

Take out the comma and see what happens.
 
allways the same error :-(- Hide quoted text -

- Show quoted text -
Click to expand...

IN this case write all the data from c1-c6 to a text file instead and
see if you have a data issue that might be preventing it from being
able to be formatted in this fashion.
 
IN this case write all the data from c1-c6 to a text file instead and
see if you have a data issue that might be preventing it from being
able to be formatted in this fashion.
Click to expand...

each of this cell containing correct number
 
Back
Top