- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Excel converts text to formulas %@#$

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

- Re: Excel converts text to formulas %@#$ posted by Harlan Grove on 16 Jan 2007
- Re: Excel converts text to formulas %@#$ posted by Gord Dibben on Tue, 16 Jan 2007