how to insert symbols in Excel ?? 
Author Message
 how to insert symbols in Excel ??

Hi,

I wonder how I could insert Word symbols in Excel.  eg. "ohm" symbol

I tried to copy Word symbols and paste them in Excel, but that doesn't
work.


Thank you



Wed, 18 Jun 1902 08:00:00 GMT  
 how to insert symbols in Excel ??

Quote:


> >I wonder how I could insert Word symbols in Excel.  eg. "ohm" symbol

> >I tried to copy Word symbols and paste them in Excel, but that doesn't
> >work.

> I assume you mean in a worksheet cell.
> I guess you are getting W when you paste the "ohm" symbol.

> Having pasted it, highlight the W in the formula bar by dragging the mouse over it and then select Symbol as the font
> from the dropdown at the left end of the formatting toolbar.  Then press Enter.

> Note that the characters in a cell can have different fonts, but when you paste characters into a cell they take on the
> default style.

> --
> Bill Manville
> Oxford, England
> Microsoft MVP - Excel

Thank you for your reply.  However, I follow exactly what you tell me to
do and I get "?" instead of an "ohm" sign.  Before I select Symbol as
the font of the cell, I get "a square" instead of "W".  Is that why I
get "?" now?  Thank you again.

PS. I am using win95 and office 97



Wed, 18 Jun 1902 08:00:00 GMT  
 how to insert symbols in Excel ??


Quote:
> Hi,

> I wonder how I could insert Word symbols in Excel.  eg. "ohm" symbol

> I tried to copy Word symbols and paste them in Excel, but that doesn't
> work.


> Thank you

When you copy and paste into Excel, the font of Excel remains in the
default.
I suggest that you
1. Note the font type of the text you copy.
2. After pasting into Excel select it
3. Change the font to the original that you copied (#1)
Hope this solves your problem.
-Michael


Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Adding extra symbols to the insert symbol box word97

2. No symbols in Insert symbols

3. Adding extra symbols to the insert symbol box word97

4. Word 2000 insert symbol - mathematical symbols

5. Insert symbol, can only see boxes where the symbols should appear

6. Adding extra symbols to the insert symbol box word97

7. **Excel 97-Inserting Symbols**

8. how to insert a symbol in excel

9. problem inserting mathematical symbols in excel

10. EXCEL 97 - Insert|Symbol ?


 
Powered by phpBB® Forum Software © phpBB Group