Error Message DataFormat.Error: We couldn't convert to Number. Details: DD1121

bpfish36

New Member
Joined
Jul 6, 2020
Messages
12
Office Version
  1. 365
I'm trying to run a Power Query on data I imported from QuickBooks to Excel. I'm comparing two ledgers from the same company to find which transactions are in both ledgers, which are in one and not the other and vice versa, however, whenever I run the query I get the above error message. I assume the query itself is working because when I run the inner join it tells me 48,164 records of 63,188 total have matched. It brings up the error when it tries to create a table. I am right-clicking "Balance Sheet", clicking "Merge", choosing two columns to match (date and name) and hitting Okay. I did see this error message can be caused by cells not being formatted correctly so I formatted the Date column as date and the Name column as text. Can somebody please tell me what I'm doing wrong, thank you in advance.
 

Attachments

  • Capture Nic Inner.PNG
    Capture Nic Inner.PNG
    36.2 KB · Views: 4

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,757
in any column you have value DD1221 (text) which you are trying to convert as a number
 

bpfish36

New Member
Joined
Jul 6, 2020
Messages
12
Office Version
  1. 365
in any column you have value DD1221 (text) which you are trying to convert as a number
Wait, are you serious?!? You mean that's an actual value? Geez, I thought it was an error code! Okay, thank you.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,757
in line Changed Type you've definition of convert to number
so DD1221 is a reason why you getting error via line Changed Type (probably)
I didn't see your M so you need to find reason and effect yourself

without the source data and code, it's all just a theory
 

Watch MrExcel Video

Forum statistics

Threads
1,109,087
Messages
5,526,767
Members
409,720
Latest member
Antwain

This Week's Hot Topics

Top