Stop Excel from auto-evaluating formula

  • Thread starter Thread starter Koya
  • Start date Start date
K

Koya

How do I prevent Excel from adding an equal sign (=) infront of a plus
sign (+)

what happens is that I have a program that exports to Microsoft Excel,
in one of the columns this data is added:
+X264 (the plus sign is part of the data because it's a unique label)

now, when I open up the excel file that this program has exported to, I
get all kinds of '#NAME?' because it's trying to calculate a forumal
when in fact the plus sign is not meant to add anything but rather is
part of a unique label.

can anyone help me? I need Excel top stop doing that and display data
as given without trying to turn it into a formula.

thanks
 
Enter an apostrophe infront of your label, e.g.

'+X264

The ' sign tells excel to treat whatever follows as a string

Cheers,

Gromit
 
Back
Top