Hi all,
I am having problems in formatting the cells after pulling/downloading data from a website.

The text i download should be in this format
-594-103
-543-966

No matter what i format the cells as (General) etc, the cells just calculate the sum and gives me this.
-697
-1509
But when i click on the actual cell, it shows the contents as
=-543-966
=-543-966
If i delete the "=", it still calculates..
Is there a way around this please?

p.s
If it helps, The code in the data-import is

WEB
1
http://website-address.php

Selection=AllTables
Formatting=rtf
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False


Thanks