Thanks again, but I don't do importing, only very minor domestic stuff.
It's my fault, everything's my fault. Ask my wife if you don't believe me.
:-))
Steve
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Not your fault entirely if the data is being imported.
>
> Very common to have numerics come in as text in that case.
>
> Just have to watch for them.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 16 Aug 2007 23:19:49 +0100, "shazzbat"
> <(E-Mail Removed)> wrote:
>
>>Right, thanks for that. See, I said it would be my fault :-))
>>
>>Steve
>>
>>"JE McGimpsey" <(E-Mail Removed)> wrote in message
>>news:jemcgimpsey-(E-Mail Removed)...
>>> In those "some" docs, the numbers are probably entered/pasted as Text,
>>> rather than numeric values.
>>>
>>> To convert them, copy a blank cell, select your 'numbers' and choose
>>> Edit/Paste Special, selecting the Values and Add radio buttons.
>>>
>>> In article <fa2gsk$oit$(E-Mail Removed)>,
>>> "shazzbat" <(E-Mail Removed)> wrote:
>>>
>>>> When I select a group of cells, in most of my excel docs, the sum of
>>>> those
>>>> cells is displayed in the bar at the bottom of the sheet.
>>>>
>>>> In some docs, it doesn't work. I've right-clicked on the bar and sum is
>>>> checked, but nothing happens. Is this my fault? Most things are.
>>>>
>>>> TIA
>>>>
>>>> Steve
>>
>
|
Similar Threads
