Add an apostrophe before the entry, this will not display and tells excel
that the entry is text.

'+0.025

"BJ" wrote:

Hi, I want to display engineering tolerances in an excel cell.
I need it to look like +0.025 and -0.001.
If I type this in excel thinks I want to add a formula, and if I set it to
numbers it removes the + or - sign...
Is their a way around this..
Many thanks Rob.