Forum Discussion

NotEinsten's avatar
NotEinsten
Regular Visitor
3 years ago

Random date error

Hi Tried following tips from a bunch of posts in here but failed to solve my problem, therefore this post. I apologize in advance if its a dublet of a former post i failed to find.   My problem is...
Need Help
NotEinsten's avatar
NotEinsten
Regular Visitor
3 years ago

Hi, thanks for replying

If I format the excel-doc to text the cells containing actual dates get turned into nonsense, so thats not an option. The same goes for converting to "standard"-type.
Below I attached a picture of the part of the excel-doc. The column acting up making error in Power BI is marked with a star. The columns marked with check mark gets imported without any trouble. All three columns are formatted as date with the same typography

ronrsnfld's avatar
ronrsnfld
Super User
3 years ago

I suspect the hyphen you see is not the result of formatting, but is a real character in the cell.  If you select a cell (in Excel) with a hyphen, and examine the formula bar, do you see the hyphen?  Again, in Excel, what is returned using the formula "=UNICODE(cell_ref)" where cell_ref refers to a cell that has a hyphen?  It may be that your failure to remove the hyphen is because it is not the standard hyphen character.