<div>
You can put a single quote &quot;&nbsp;' &quot;&nbsp;in the cell prior to pasting.
</div>


You can put a single quote " ' " in the cell prior to pasting.

<div>
I can't alter the data coming in... it's being pulled in from a database via sql code embedded in a VBA module I wrote, and the string is in the database as &quot;487684E40&quot;.
</div>


I can't alter the data coming in... it's being pulled in from a database via sql code embedded in a VBA module I wrote, and the string is in the database as "487684E40".

<div>
<div class="content wysiwyg-content">
Hello-- I am using Excel 2007, and when I try to paste the string &quot;487684E40&quot; into a cell with format set to &quot;General,&quot; Excel is automatically assuming the &quot;E&quot; represents an exponent so it's &quot;helping me out&quot; and automatically changing the format to &quot;Scientific&quot; and changing &quot;487684E40&quot; to &quot;4.88E+45.&quot;<br />
<br />
How do I shut this functionality off? I need it to stay format &quot;General&quot; and value &quot;487684E40&quot; when I paste it in.<br />
<br />
Thanks a lot!
</div>
</div>


Hello-- I am using Excel 2007, and when I try to paste the string "487684E40" into a cell with format set to "General," Excel is automatically assuming the "E" represents an exponent so it's "helping me out" and automatically changing the format to "Scientific" and changing "487684E40" to "4.88E+45."

How do I shut this functionality off? I need it to stay format "General" and value "487684E40" when I paste it in.

Thanks a lot!

Crazy Excel Quirk

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.