imported data into excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My bank has recently changed its website presentation.

I normally copy and paste data from my web bank account page into an excel
spreadsheet. The data in three columns contains date, text, and amounts in
numbers. Now however, I can format layout, text etc but for some reason the
date cells cannot be formatted nor can the numbers be added to give a total.

The cells seem to be "inert". Is there a way of rectifying this within Excel??
 
Midas

Enter a 1 in a blank cell. Copy it. Go to your numbers and dates and
edit>paste special>Values + Multiply. You will need to format the cells as
dates and numbers now, but that should kick them back to life

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I link data in three different cells? ck# date amount 2
Comparison of columns using Conditional Formatting 3
Can't remove formatting from copied data in Excel worksheet 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how do i import data from a web page into excel 2007? 1
Converting a date to a text field w/o converting it to a julian da 2
Sort Not Working on Column of Numbers 4
Peculiar default cell format 1

Back
Top