View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Unknown number format

Adjust your column wider. It will do the trick.

"Don" wrote:

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