Crazy Excel Quirk

Posted on 2012-08-22
Last Modified: 2012-08-22
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!
Question by:Jeff9687
    LVL 25

    Expert Comment

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

    Author Comment

    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".
    LVL 25

    Accepted Solution

    LVL 26

    Assisted Solution

    Hi, Jeff9687.

    Can you define the format of the cell the value is being pasted into as "Text"?

    If so, it should display it as "487684E40". However, Excel can be funny about "Text" formatting so it's best to then "extract" the data to a General-formatted cell by using a formula such as


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now