csv-files with '+' in field -> treated as formula

D

dave

When I make up a CSV-file (from our oracle-database) we
have to fill in a line like this:
9603144;01;TEST;+BE;01/01/1000;31/12/9999

When opening the file in Excel, the 4th field (+BE) is
treated as a formula, but that is not an option.

Anyone have an idea how to write it in the CSV-file so
that it is treated as a text-field but without showing any
quotes (so I would like to see +BE and not '+BE)

Tnx already in advance!
Dave
 
D

dave

found something myself: just add a space before the + and
it's ok

if anyone has another idea: post it
 
Top