[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

Excel 2013 - Paste data from web page

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
copied.jpg
thanks,
0
csehz
Asked:
csehz
1 Solution
 
Richard DanekeCommented:
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.
0
 
csehzAuthor Commented:
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
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now