Custom Number Format
 

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

Custom Number Format
 

TeddyTash wrote:
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"

Custom Number Format
 

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


TeddyTash wrote:

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

--
TeddyTash

--

Dave Peterson