T
Tom
Excel 2003 SP3
I downloaded some Yahoo data that is coming across as text. My spreadsheet
columns need to change the format to numeric or date depending on the column.
Here's the situation: there's a small green upward-left pointing arrow
signifying that the cell is text. The group of cells were copied/pasted from
Yahoo. (maybe next time I should paste-special??) I've attempting to
highlight all the cells and change them from text to numeric or text to date
but I'm unsuccessful. Dates are 1-May-08 instead of the 5/1/2008 format that
I desire. Numeric text is showing as 6.21 (text) vs the 6.21 that I desire
in a numeric format.
So, how can I remove the text (green arrow) format and replace it with the
proper numeric format. All things I've tried don't work (Format>Cells>select
ANYTHING!!).
TIA,
I downloaded some Yahoo data that is coming across as text. My spreadsheet
columns need to change the format to numeric or date depending on the column.
Here's the situation: there's a small green upward-left pointing arrow
signifying that the cell is text. The group of cells were copied/pasted from
Yahoo. (maybe next time I should paste-special??) I've attempting to
highlight all the cells and change them from text to numeric or text to date
but I'm unsuccessful. Dates are 1-May-08 instead of the 5/1/2008 format that
I desire. Numeric text is showing as 6.21 (text) vs the 6.21 that I desire
in a numeric format.
So, how can I remove the text (green arrow) format and replace it with the
proper numeric format. All things I've tried don't work (Format>Cells>select
ANYTHING!!).
TIA,