How to convert Data type from Text to Number

Question

I am trying to change this column to a data type number. The values are numbers, I've trimmed the values but whenever I try to convert to number, it still throws an error.&nbsp;&nbsp;

tob_p · Answer

Hard to see what might be the issue but the error message is pointing to the zero being the issue (could be everything to be honest, it's probably just flagging that as it's the first in the list).

I take it you've tried to convert to number without trimming first - not sure why you would need to do this. Otherwise generally this error would flag up when there's perhaps a bit of text in the column or something like a #N/A

clk245 · Answer

Yep, I've tried converting without trimming, I've tried replacing values and trying to find any erronious values or text.&nbsp;

tob_p · Answer

Do you have a sample of what's in that column at source?

clk245 · Answer

&nbsp;

clk245 · Answer

I made sure that the column also was in the number format as well.

Forum Discussion

How to convert Data type from Text to Number

8 Replies

Related content

convert week number into data

Convert text to number

Convert Dynamic Data source

Convert Number to Date

data converted automatically to decimal numbers