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

  • Thread starter Thread starter dave
  • Start date Start date
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
 
found something myself: just add a space before the + and
it's ok

if anyone has another idea: post it
 
Back
Top