importing data from webpage and using it.....

  • Thread starter Thread starter montecarlo
  • Start date Start date
M

montecarlo

Hello, I am trying to import information from my verizon cell phone bill
which u can look at online.

The import procedure works fine just copying and pasting. It puts the
separates the data into columns properly.

The big thing tho is in the time column I want to be able to use that
as a time.... not text. Excel doesn't see it that way. Even if I type
timevalue(C2) where C2 is a cell containing the time it gives me
#value

So how do I convert it to a time. I did notice that there is no space
between that time and AM or PM (ie: 08:00PM) so I tried a substitute
function and added a space but it still doesn't work....
 
Try selecting your range of "times" and
edit|replace
PM
with
(Space)PM
" PM" (w/o the quotes)

When I did a small test, excel reevaluated those cells as times.
 
Thanks, I just tried it and still doesn't get it. If I manually type a
time in a cell exactly the same way that it gets imported and then do
that it works ok. Something about importing stuff.

The same thing happens in the minutes column. The only thing in each
cell in that column is a number. And no matter what I do I can't get
excel to treat it as a number. I have tried copying an empty cell and
paste special... and that don't work either.

:( I know those guys at verizon are rippin me off wish I could get
this to work.
 
There always seems to be a space after everything. For example:

"08:00 PM "

instead of

"08:00 PM"

i manually deleted the space and it works ok. Why doesn't the function
TRIM take care of that?

Even if I do edit->replace or a substitute function it still adds that
space at the end
 
Back
Top