email address formatting in Calc

[phalbe henriksen <ph...@gmail.com>]

Hi.

I have a Calc spreadsheet that contain about 400 email addresses. They are
formatted as plain text, hyper-linked in blue and underlined, and
hyper-linked in blue, underlined with a gray background.

How can I change the special formatting and make them all plain text?
Nothing I've tried works.

Thanks.

Phalbe Henriksen
working on 50th class reunion

Re: email address formatting in Calc

[Don Daugherty <dd...@sunflower.com>]

On 3/31/2014 7:21 PM, phalbe henriksen wrote:
> Hi.
>
> I have a Calc spreadsheet that contain about 400 email addresses. They are
> formatted as plain text, hyper-linked in blue and underlined, and
> hyper-linked in blue, underlined with a gray background.
>
> How can I change the special formatting and make them all plain text?
> Nothing I've tried works.
>
> Thanks.
>
> Phalbe Henriksen
> working on 50th class reunion
>
You might try using Paste Special, i.e.,
1.  Create a new sheet in the same spreadsheet file
2.  On the page containing the email addresses select the block of cells 
containing the addresses and press Ctrl+C.
3.  Then go to the new page and press Shift+Ctrl+V (or Click Edit > 
Paste Special...).  This brings up the Paste Special dialog box.  Under 
Select, check Text, Numbers, and Date&Time, and uncheck all other 
choices.  Under Options nothing should be checked; under Operations only 
None should be dotted, and under Shift Cells only Don't Shift should be 
dotted.  Click OK.

If this does what you want, you can replace step 3 with
3'.  Press Shift+Ctrl+V (or Click Edit > Paste Special...).  This brings 
up the Paste Special dialog box.  Under Select, check Text, Numbers, and 
Date&Time, and uncheck all other choices.  Under Options nothing should 
be checked; under Operations only None should be dotted, and under Shift 
Cells only Don't Shift should be dotted. Click OK.  In other words, you 
can Paste Special back into the original cells, thus  converting them to 
the desired  format.


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com


-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: email address formatting in Calc

[Tubular <tu...@iinet.com>]

Under Tools select Autocorrect ; Options ; uncheck URL Recognition


phalbe henriksen wrote:
> Hi.
>
> I have a Calc spreadsheet that contain about 400 email addresses. They are
> formatted as plain text, hyper-linked in blue and underlined, and
> hyper-linked in blue, underlined with a gray background.
>
> How can I change the special formatting and make them all plain text?
> Nothing I've tried works.
>
> Thanks.
>
> Phalbe Henriksen
> working on 50th class reunion
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2241 / Virus Database: 3722/6776 - Release Date: 03/31/14
>