NumberFormat in Excel

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • MaTe
    #1

    NumberFormat in Excel

    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
    Tags: None
    • scorpion53061
      #2
      Re: NumberFormat in Excel

      On May 22, 3:49 am, MaTe <matelk...@gmai l.comwrote:
      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
      Take out the comma and see what happens.

        Comment

        • MaTe
          #3
          Re: NumberFormat in Excel

          On May 22, 6:48 pm, scorpion53061 <kellyjmart...@ gmail.comwrote:
          On May 22, 3:49 am, MaTe <matelk...@gmai l.comwrote:
          >
          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
          >
          Take out the comma and see what happens.
          allways the same error :-(

            Comment

            • scorpion53061
              #4
              Re: NumberFormat in Excel

              On May 22, 12:42 pm, MaTe <matelk...@gmai l.comwrote:
              On May 22, 6:48 pm, scorpion53061 <kellyjmart...@ gmail.comwrote:
              >
              >
              >
              >
              >
              On May 22, 3:49 am, MaTe <matelk...@gmai l.comwrote:
              >
              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
              >
              Take out the comma and see what happens.
              >
              allways the same error :-(- Hide quoted text -
              >
              - Show quoted text -
              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.

                Comment

                • MaTe
                  #5
                  Re: NumberFormat in Excel

                  On May 22, 9:16 pm, scorpion53061 <kellyjmart...@ gmail.comwrote:
                  On May 22, 12:42 pm, MaTe <matelk...@gmai l.comwrote:
                  >
                  >
                  >
                  On May 22, 6:48 pm, scorpion53061 <kellyjmart...@ gmail.comwrote:
                  >
                  On May 22, 3:49 am, MaTe <matelk...@gmai l.comwrote:
                  >
                  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
                  >
                  Take out the comma and see what happens.
                  >
                  allways the same error :-(- Hide quoted text -
                  >
                  - Show quoted text -
                  >
                  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.
                  each of this cell containing correct number

                    Comment

                    Previous template Next
                    Working...