[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

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

[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" wrote in message
...
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.

[bj]

Many thanks for your help...

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