engineering tolerances

[BJ]

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.

 

[Dennis]

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

'+0.025

 

[Bob Phillips]

Use a custom format of

+0.000;-0.000

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[BJ]

Many thanks for your help...