if you just want to use a fixed character in front of your values you
may enter the following in the custom format:
just type this within the inputbox for this category. Not sure what you
mean with 'enter formula'
> I am trying to formatt the cell to show a L##.## (eg K34.9)
> Have gone into format, cells, then custom or special.
> Don't know how to change the special type and can not
> figure out how to enter formula in custom. Can this
> actually be done?