Excel converts text to formulas %@#$

Giganews Newsgroups
Subject: Excel converts text to formulas %@#$
Posted by:  Henryk Birecki (soaringpil…@sbcglobal.net)
Date: Tue, 16 Jan 2007

I wish Microsoft stopped developing "helpful" programs. All their
"auto" stuff leads to nothing but problems. Here is an example:

I have to process data which come as CSV files and contain entries
that look like multiplication e.g "3*4". Damn Excel can't handle
these. Every chance it gets, it turns them into "=3*4" and displays
"12".

Any one knows how to kill this behaviour? Please share the knowledge.

Henryk Birecki

Replies