Excel 2013 - Paste data from web page

Posted on 2014-08-08
Last Modified: 2014-08-11
Dear Experts,

I never knew the answer on this so just would like to ask,

if on a web page the data are in this format like on the picture, so number or text but the separator is the '.' character for 5.5

Original format on the web page
then pasting that into Excel why it becomes date, seems understanding that 05-may
Question by:csehz
    LVL 18

    Accepted Solution

    When you paste in an unformatted cell, Excel attempts to format the data as a type.   It sees the 5.5 as a month/day combo.

    Sometimes it guesses poorly.   If you paste into a cell that has been formatted for a number, it will present the number correctly.  Or, if you paste a number into a cell formatted as a date format, it will be formatted as a date!

    Thank you for asking.
    LVL 1

    Author Comment

    Thanks for your advice, finally I had success with formatting the column to Text preliminary, after pasted to there the data with selecting Paste Special/Values

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now