Custom Number Format

[TeddyTash]

Hi,

Hope you guys can help.

If I have the following info:

A1 = 5
A2 = -4
A3 = 0

How can I use Format Cells > Custom to have them display as:

A1 = 5 up
A2 = 4 dn
A3 = Level

I've been trying and trying but keep getting a message that I should
use one of Excel's pre-defined formats.

Hair being pulled out!


Thanks in advance,
Teddy

 

[smartin]

Hi,

Hope you guys can help.

If I have the following info:

A1 = 5
A2 = -4
A3 = 0

How can I use Format Cells > Custom to have them display as:

A1 = 5 up
A2 = 4 dn
A3 = Level

This works for me as a custom number format in E2003:

0 " up";0 " dn";"level"

 

[Dave Peterson]

Try something like:
General" up";General" dn";"Level";@
(Positive;negative;0;text)
or
0.00" up";0.00" dn";"Level";@
(if you like decimals.)