Forum Discussion
Dataformat.Error: We couldn't convert to 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
Solution 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
- MatheusCezarNew Member
I dont know what i did but putting it to text format worked , so thanks
- AnonymousNot 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
- MatheusCezarNew 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.
- MatheusCezarNew Member
How do i solve it?