Re: Adding durations/phone bill

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Pete,

I'm a bit lost here now, I don't know if Ian was replying to you or me. As
you have experience of downloading Vodafone data I will bow out and leave
you to help Ian,

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk


"Pete_UK" <pashurst@xxxxxxxxxxx> wrote in message
news:3be50d04-3cd0-439a-bb0e-f6c7a666c75e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Just continuing with this, then, a non-formula approach is to
highlight the column of data, then CTRL-H (Find & Replace) -

Find What : (i.e. colon)
Replace With : (also a colon)

Click Replace All.

Hope this helps.

Pete

On Nov 26, 7:52 pm, "Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote:
Just took a small sample and over wrote the colons. It works but can't do
that for the whole doc.

"Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote in message

news:fif6a6$snt$1$830fa79d@xxxxxxxxxxxxxxxxxxx



Tried that get :- "MS excel cannot find matching data to replace. No
cell
in the selection contains what you typed, or no records match the
criteria".
I did see the numerals entered and I'm using Num lock on a
laptop....Just
in case that means something.
Cheers me dears.

"Sandy Mann" <sandyma...@xxxxxxxxxxxxxx> wrote in message
news:O$GTG2FMIHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
I always suspect that downloaded data contains non-breaking spaces
character 160. Try highlighting the data and the selecting Edit >
Replace. In Find What: enter 0160 from the number pad NOT the numbers
over the letter keys. (you will not see anything entered in the dialog
box
because it is a space.) Leave the Replace with empty and select Replace
all. If that does not correct the problem then Then do the same but
use a
space instead of 0160

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandyma...@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk

"Ian" <i...@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:fif33n$mc9$1$8302bc10@xxxxxxxxxxxxxxxxxxx
Hi
I'm trying to add the durations on my phone bill (yes it was a
biggie!!).
Tried various things including formatting the cells to custom
hh:mm:ss.
High light a cell, click sigma, select range of cells, enter.
00:00:00
everytime.
I'm using excel '97 that comes with office pro '97 or something like
that.
The original file was downloaded from Vodafone as an excel and is
colon
separated.
Any ideas? Any other aplications I could paste into that would do it?
Cheers me dears
BB- Hide quoted text -

- Show quoted text -




.

Relevant Pages

  • Re: Adding durations/phone bill
    ... Have been off-line for a while - looks like Ian has sorted it out. ... Basically, the data is text (in an Excel file), so it has to be ... High light a cell, click sigma, select range of cells, enter. ...
    (microsoft.public.excel)
  • Re: Printing wrapped cell not WYSIWYG
    ... Ian S wrote: ... The text to the left of the cell is hidden. ... > problem only occurred for files transfered from Excel for Windows. ... as said, this is just a clue, let us know if it points you out... ...
    (microsoft.public.mac.office.excel)
  • Re: Create a pseudo Calender?
    ... "Ian" wrote: ... Copy this cell across the sheet as far as you need. ... Excel only has 254 columns. ... Is there a template available somewhere, ...
    (microsoft.public.excel.misc)
  • Re: Create a pseudo Calender?
    ... "Ian" wrote: ... Excel stores dates a numbers starting from 1 Jan 1900 making your ... Using Excel 2003. ... Copy this cell across the sheet as far as you need. ...
    (microsoft.public.excel.misc)
  • Re: Conditional Sum Wizard woes
    ... Those curly braces mean it is an array formula and CANNOT just be put into the ... "Ian" wrote in message ... > Note the curly bracket which show up if I click on the cell it populated. ...
    (microsoft.public.excel.newusers)