Hi,

I have some data i'm pasting into excel. One column of data i would like is, for example, +140/132.

I would like a column of numbers in this format (+xxx/xxx) once i have applied to colunm using the text to column function.

The problem i have is that once these numbers are in their column, excel automatically assumes this is a division and shows the sum of 1.06818 (140/132)

Is there a way to stop this calculation so that it just shows +140/132?

Thanks