No I didn't say "abracadabra"!
:)
Thanks for the assistance and advice.


" wrote:

Cindy wrote:
i looked at my cell formats and they are set up as number formats.
i believe i did this after i exported to excel from quickbooks.????????

But did you say "abracadabra"? :-)

As I said, the problem might arise because of the prior state of the
cells before the data was entered. Simply changing to a Number
format after the import might not remedy the problem. And the fact
that cells have a Number format now might not be relevant to
understanding the root cause of your problem.

In any case, these types of user errors are very difficult to triage in
this kind of forum. If you can post the xls file, that might help.
(Albeit not my usual choice of practice.)

PS: I am not familiar with Quickbooks or the procedure for importing
Quickbooks data into Excel. You might search the QB FAQs for
some hint of a remedy for your problem, if you are still stuck.

Good luck!