engineering tolerances

B

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.
 
D

Dennis

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

'+0.025
 
B

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)
 
Top