In filling analytical and other results into tables, if a relation should be
expressed (i.e. ï‚£20 ppm = €œunder the limit of detection€�), a vast majority of
people used to record directly this script. The format, however, accomodates
to a text one, which prevents the range from being taken into further
calculations or from changing the number of decimal places. The help is
principally simple, by adding the relation sign ahead of the bare numeric
format. This can be automatically accomplished by a very simple macro, as

Sub LessGreater()
'Sub adds a sign i.e. '<', before formatted content of the selected cell(s).
Dim Cell As Range
Static Chars As String
Chars = InputBox("<= < = etc.", "Add a sign before the number",
Chars)
For Each Cell In Selection
If IsNumeric(Cell) Then Cell.NumberFormat = Chars & Cell.NumberFormat
Next
End Sub

Unfortunately it seems that adding associated signs (Chr(163) and Chr(179))
from the Symbol font can be achieved neither programmatically nor manually
before Vista and UNICODE. Is it true?

Thanks for your conforming my opinion

--
Petr Bezucha