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: 49

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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,127,479
Messages
5,625,005
Members
416,065
Latest member
meiravmeron

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top