mathematical symbols

  admas 13:25 16 Jan 2007
Locked

How can I insert mathematical symbols into an Excell 2000 worksheet? I am particularly interested in symbols for 'equal to or greater than'.

  rawprawn 13:45 16 Jan 2007

Oo the Toolbar/Insert/Symbol

  VoG II 14:20 16 Jan 2007

Hold down ALT and on the numeric keypad type 0179

then change the font to Symbol.

To see what symbols are available run the following code:

Sub test()
Dim i As Integer
For i = 1 To 255
Cells(i, 1).Value = Format(i, "0000")
Cells(i, 2).Value = Chr(i)
Next i
Columns("B:B").Font.Name = "Symbol"
End Sub

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Ryzen news - release date, UK price, features and specifications

The 12 best apps for drawing and painting on your iPad

Mac power user tips and hidden tricks

Comment faire des captures d’écran sous Windows 10 ?