Column format

[prsasth_s01]

hi When i paste the number + 51 - 1- 211- 6500 it becpmes -6661..Looks like its summing up very thing..I tried all format types..but not working pls help

[Palmetto]

Excel is interpreting the symbol ( + and - ) as math operators and calculating the numbers per the order of operations.

Prepend your entry with a single apostrophe to force Excel to see this as text entry.

'+ 51 - 1- 211- 6500