Below is the data:
1) +9180 33575586 - Copied shows correctly on excel 2) +9180-33575625 - Copied shows just -33566445 on excel.
On read tab looks like =9180-33575625. Please advice this is creating me issues while exporting
Below is the data:
1) +9180 33575586 - Copied shows correctly on excel 2) +9180-33575625 - Copied shows just -33566445 on excel.
On read tab looks like =9180-33575625. Please advice this is creating me issues while exporting
The reason why Excel changes it from +9180-33575625 to -33566445 is because Excel reades the first + sign as a start of an equation. This can be avoided by adding a single quote at the start i.e. '+9180-33575625.