Excel manipulation

I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My requirement is not to get the ' (single quote) in the output when opened in excel

Any suggestions plz

Hello Devaraj,

Do you think it's the correct forum to place your query?

I hope it's Not.

How ever, in excel you to manually "format the column in which you are getting "E+e" and change the number properties to "general".

Regards
Ravi