Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2014, 07:41 AM
ncbergst ncbergst is offline Copying and pasting acount data into Excel as text will not reformat to a number or currency Windows 8 Copying and pasting acount data into Excel as text will not reformat to a number or currency Office 2013
Novice
Copying and pasting acount data into Excel as text will not reformat to a number or currency
 
Join Date: Sep 2014
Posts: 2
ncbergst is on a distinguished road
Default Copying and pasting acount data into Excel as text will not reformat to a number or currency

From the Vanguard account website, the download function for the cost basis screen is not available. Copying and pasting the data as text goes into Excel pastes okay into separate columns that match the website, but I cannot get the value cells to reformat as currency or numbers that can be used for analysis. The buttons are all available and no error messages come up when attempting to reformat, but the cells apparently stay as text that cannot be summed, averaged, etc. Is there something that needs to be done first that I'm missing? Thanks!
Reply With Quote
  #2  
Old 09-02-2014, 08:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Copying and pasting acount data into Excel as text will not reformat to a number or currency Windows 7 64bit Copying and pasting acount data into Excel as text will not reformat to a number or currency Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps format cells as " General" before pasting ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 09-04-2014, 08:50 AM
ncbergst ncbergst is offline Copying and pasting acount data into Excel as text will not reformat to a number or currency Windows 8 Copying and pasting acount data into Excel as text will not reformat to a number or currency Office 2013
Novice
Copying and pasting acount data into Excel as text will not reformat to a number or currency
 
Join Date: Sep 2014
Posts: 2
ncbergst is on a distinguished road
Default Getting HTML Data Formatted in Excel 2013

Hello Pecoflyer,

Thank you very much for your suggestion, but I'm not sure what you mean. The Excel spreadsheet is already formatted general and when I copy the numbers in as text, Excel allows me to reformat the cells to numbers or currency but it still interprets the contents as text even though Excel thinks it is now a number or currency.

Thanks again. ncbergst
Reply With Quote
  #4  
Old 09-04-2014, 11:29 AM
gebobs gebobs is offline Copying and pasting acount data into Excel as text will not reformat to a number or currency Windows 7 64bit Copying and pasting acount data into Excel as text will not reformat to a number or currency Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

In cases such as this, all you need to do is go in and retype one of the characters and I think Excel comes out of its coma and knows its a number. Alternatively, you can do a find/replace for some common character, perhaps a decimal or a dollar sign.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying and pasting acount data into Excel as text will not reformat to a number or currency Loop through Word doc to find and reformat text Sandy27 Word VBA 5 01-06-2014 03:48 PM
Copying data from Project to Excel OTPM Project 13 12-20-2013 10:25 AM
copying and pasting Excel tables into Word derohanes Word 1 01-24-2013 12:07 AM
Copying and pasting acount data into Excel as text will not reformat to a number or currency Copying and pasting from Excel Lorna B Word 1 03-20-2012 11:58 PM
Copying and pasting acount data into Excel as text will not reformat to a number or currency Maintain formatting while copying text from word, and pasting into a webpage. kdogg121 Word 1 07-07-2009 02:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft