Division Sign

J

James Hamilton

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
 
M

MyVeryOwnSelf

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

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

Hold down the "Alt" key while typing these 4 digits on the numeric keypad:
0184.

Then set the font to "Symbol" for the cell.

Hope this helps.
 
P

Peo Sjoblom

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


Regards,

Peo Sjoblom
 
B

Bagua

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! :)
 
D

Dave Peterson

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)
 
P

Peo Sjoblom

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
 
D

Dave Peterson

Slightly shorter:

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

<vbg>

Peo said:
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
Click to expand...
 
D

Dave Peterson

If you insert a new row 1, you'll see a difference.

By (my opinion only) in cases like this, I don't see much difference at all.

And if you start in a cell that's not in row 1, you'll see a difference.
 
J

James Hamilton

Thanks everyone.

Dave Peterson said:
If you insert a new row 1, you'll see a difference.

By (my opinion only) in cases like this, I don't see much difference at all.

And if you start in a cell that's not in row 1, you'll see a difference.
Click to expand...
 
Top