Forum Discussion
Error : Cannot convert value " of type Text to type Integer
Hi, Can someone please explain (in a non technical way) how I fix the above error I have data coming through sa listed below <div>116</div> <div>18</div> I'm unable to change the data s...
I would suggest fixing this issue from inside the Edit Queries section. What you need to do is to remove the <div> and the </div>. Then you will be left with something you can convert to Number.
The easiest method is to open Edit Queries. Find the query that contains these values. Click on the column with these values and do this:
- Select the column with a left click
- In the Home area of the ribbon, locate "Replace Values". Put <div> in the first box and leave the second box empty
- Repeat the last step again but use </div> in the first box.
- Now click on the icon on the left hand side of the column name and change the datatype to Whole Number.
- Close and apply.
Finally! I've been working on this for way too long.
My issue wasn't specifically the "<div>" existing in my table, but this suggestion sent me down the path of considering some possible blank or null rows in the source (I had assumed there were none). Once I filtered out all blank rows, my date conversion worked perfect.
Thank you!