Thread: Division Sign
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Division Sign

Another way, copy down this formula 255 rows

=CHAR(0&ROWS($A$1:A1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Dave Peterson" wrote in message
...
In xl2002+, you can use Insert|Symbol.

So if you don't run xl2002+, you'll have to find a different way.

You can hit flying windows R (or windows start button|Run)
type charmap
hit enter

or even
windows start button|Programs|accessories|System tools|charmap
if you like to mouse.

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)

Bagua wrote:

Hello Peo,

Is there a way to display all the different Alt + Number possibilities
such as
the one you noted? I notice that Alt + 1 I get a smile and so on, I'd
like to
see them all listed.

Thank you, this is very handy! :-)

"Peo Sjoblom" wrote:

Arial font, hold down alt key, type 0247 on the numpad, release alt
press enter


Regards,

Peo Sjoblom



"James Hamilton" wrote:

Hi,

Does anyone know how to insert a "divided by" sign into a cell -
perhaps
using wingdings?

I don't want this "/" but more like "./."

I hope that makes sense - thanks in advance


--

Dave Peterson