1

I'm not sure why, but since a few days ago when I import a .csv it is adding a "=" infront of cells which begin with an @.

It should be like this:

enter image description here

But now it is doing this:

enter image description here

I've compared all my settings to a machine that can open it up fine and it's identical really. It's also same version of Office.

karel
  • 13,706
Ed Briscoe
  • 71
  • 1
  • 1
  • 4

1 Answers1

1

Excel's default and preferred character for starting a formula is =. However Lotus 1–2–3 uses + or - and Apple Works uses @ so Excel also supports them for compatibility

That means if the cell starts with any of the +-=@ characters you'll get a formula. To prevent that from happening prepend ' at the start of the cell. Or force Excel to recognize the formula column as text by selecting Data > Get External Data > From Text, open your CSV file and select the desired type in Text Import Wizard

For more information read

phuclv
  • 30,396
  • 15
  • 136
  • 260