Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?


"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?




alistew wrote:

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson


--

Dave Peterson

Hi

I am using Office 2003.

I just wanted to replace the word Degree with the degree symbol.

thanks again.

alison

"Dave Peterson" wrote:

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?




alistew wrote:

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson


--

Dave Peterson

Maybe you can try this in excel:

Tools|autocorrect options|autocorrect tab

Type: degree
in the replace box

Hold the altkey while typing 0176 on the number pad
in the with box.


alistew wrote:

Hi

I am using Office 2003.

I just wanted to replace the word Degree with the degree symbol.

thanks again.

alison

"Dave Peterson" wrote:

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?




alistew wrote:

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

hi

i have found a way of doing this. i used the alt+0176 to insert it into my
autocorrect.

thanks for you help anyway.

also do you know where i can get a list of these codes?

"Dave Peterson" wrote:

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?




alistew wrote:

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson


--

Dave Peterson

Start|Run|CharMap
and hit ok.



alistew wrote:

hi

i have found a way of doing this. i used the alt+0176 to insert it into my
autocorrect.

thanks for you help anyway.

also do you know where i can get a list of these codes?

"Dave Peterson" wrote:

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?




alistew wrote:

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

ps. If you're using office 2002+, you can use:
Insert|symbol

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

alistew wrote:

hi

i have found a way of doing this. i used the alt+0176 to insert it into my
autocorrect.

thanks for you help anyway.

also do you know where i can get a list of these codes?

"Dave Peterson" wrote:

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?




alistew wrote:

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

"Dave Peterson" wrote:

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.



alistew wrote:

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson