Forum Discussion

MatheusCezar's avatar
MatheusCezar
New Member
8 years ago
Solved

Dataformat.Error: We couldn't convert to Number

DataFormat.Error: Não foi possível converter para Number. Detalhes: 010002-1
I just keep getting the error with this tipe of number
 
  • Not sure what your question is.

     

    That error, without knowing any spanish, I'm guess says it can't convert the format ####-# to a number.

     

    Depending on what results you neeed a couple of options -

    Keep it as text

    Somehow format the column to get rid of the dash and then format as number

6 Replies

  • Aron_Moore's avatar
    Aron_Moore
    Icon for Solution Specialist rankSolution Specialist

    Not sure what your question is.

     

    That error, without knowing any spanish, I'm guess says it can't convert the format ####-# to a number.

     

    Depending on what results you neeed a couple of options -

    Keep it as text

    Somehow format the column to get rid of the dash and then format as number

    • MatheusCezar's avatar
      MatheusCezar
      New Member

      I dont know what i did but putting it to text format worked , so thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    What type of data you have in the source ? are they numeric? Are you trying to change from some other data type to Numeric ?

     

    Thanks

    Raj

    • MatheusCezar's avatar
      MatheusCezar
      New Member

      They came as numbers from excel. I tried editing them to text in excel also, but it didnt solve. These numbers when they came without the "-" they recognize normally im Bi.