Unknown number format

[Guest]

I've never had this happen before. I am using a product called Monarch to
pull numbers out of a ASCII report and drop them into an excel sheet. I've
been using this app for 11 years without this problem.

In excel, I'm trying to use the SumIf function to add all numbers that apply
to specific invoices. The problem is this: I'm getting a result in the SumIf
function that looks like scientific notation. All of the cells are formatted
as "general". Can someone tell me what I'm doing wrong?

 

[Guest]

Adjust your column wider. It will do the trick.