|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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!
|
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 from Excel | Lorna B | Word | 1 | 03-20-2012 11:58 PM |
Maintain formatting while copying text from word, and pasting into a webpage. | kdogg121 | Word | 1 | 07-07-2009 02:50 AM |