mathematical symbols

  admas 13:25 16 Jan 07
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 07

Oo the Toolbar/Insert/Symbol

  VoG II 14:20 16 Jan 07

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.

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…