Converting exponential data to text format

[Vignesh Veerasamy]

Dear Gurus,

My data is in form of 35E260 in ERP when I am copy & pasting in excel it is shown as 3.5E+260 how can i get the same as shown in ERP?

Kindly guide.Thanks in advance.

 

[Deepak]

Can we have the sample data in excel with pre & post scenario.

 

[Vignesh Veerasamy]

Can we have the sample data in excel with pre & post scenario.

Hi Deepak,

Pl find the sample file

 

[NARAYANK991]

Hi ,

If you format the destination cell(s) as Text , then copying and pasting 35E61 will not convert it to 3.50E+62

Narayan

 

[Deepak]

First u need to format the columns/rows/range {where data needs to to paste} in to text format!!

 

[Vignesh Veerasamy]

Hi ,

If you format the destination cell(s) as Text , then copying and pasting 35E61 will not convert it to 3.50E+62

Narayan

Thank you Narayan sir.

 

[Somendra Misra]

Hi Vignesh,

Might be I am wrong, when tested in Excel 2010, only changing the cell format to TEXT will not resolve this issue as when you will paste the data the number format will automatically be change to Scientific. So you need to format the cell as TEXT and when pasting use Paste Special dialogue box using ribbon button or shortcut Ctrl+Alt+V, and select Text as shown below to get in correct format.



Regards,

 

[Vignesh Veerasamy]

First u need to format the columns/rows/range {where data needs to to paste} in to text format!!

Dear Somendra,

This option is not working.
I tried with option of Deepak & Narayan sir & found working fine.



View attachment 20492

Thank you Deepak.

Hi Vignesh,

Might be I am wrong, when tested in Excel 2010, only changing the cell format to TEXT will not resolve this issue as when you will paste the data the number format will automatically be change to Scientific. So you need to format the cell as TEXT and when pasting use Paste Special dialogue box using ribbon button or shortcut Ctrl+Alt+V, and select Text as shown below to get in correct format.

View attachment 20602

Regards,