View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Don is offline
external usenet poster
 
Posts: 487
Default Unknown number format

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?

--
Don Rountree