negative time - imported data

[Bossie]

hello again

I have an excel sheet with imported data. In column F some strange things happened...
It contains time values, but some are negative. Negative values are shown as #value or as 0.
But in the formulabar I see =-11:37.
Excel seems to interpret this as an area (eleven columns to the left and 37 rows down) which generates an error, cause it's in column F...
I tried to copy the value in column F (with formulas as value() or text() or even left() but it doesn't work.
Is there a way to copy the content of the cell (-11:37)?

I attached the file.


thx

 

[BBD]

Hi Bossie,

There are 2 ways of doing this.

1. Change the format of the cell to text. Press F2 in the cell and press enter. The formula will be treated as text.

2. Another of way of doing it is just to include ' (single apostrophe) at the beginning of your cell. This will change it to text from formula.

Hope this helps.

Thanks,
BD

 

[Bossie]

Thx a million BD!