Formattin a Number with String

[Syed Zeeshan Haider]

Hello Experts,
I have Excel 97 Pro on Win98SE.

In certain situations we need to display a string with a number in a cell
and use the actual numerical amount (without string) in calculations. This
happens when we format a cell to display a currency sign, %age sign etc. In
this way can we define our own strings to be displayed with a number in a
cell?

Thank you,

 

[Ron Rosenfeld]

Hello Experts,
I have Excel 97 Pro on Win98SE.

In certain situations we need to display a string with a number in a cell
and use the actual numerical amount (without string) in calculations. This
happens when we format a cell to display a currency sign, %age sign etc. In
this way can we define our own strings to be displayed with a number in a
cell?

Thank you,

Format/Cells/Number/Custom/Type: 0.00" your string"

Look up Number Format Codes in HELP for more information.


--ron

 

[Guest]

You should be able to use a custom number format

Examples
#" mysymbol
0" mysymbol
"mysymbol "
"mysymbol "

When you create a custom number format you can see the displayed result just above where you are entering the custom style

Good Luck
Mark Graesse
(e-mail address removed)



----- Syed Zeeshan Haider wrote: ----

Hello Experts
I have Excel 97 Pro on Win98SE

In certain situations we need to display a string with a number in a cel
and use the actual numerical amount (without string) in calculations. Thi
happens when we format a cell to display a currency sign, %age sign etc. I
this way can we define our own strings to be displayed with a number in
cell

Thank you
-
Syed Zeeshan Haider
http://szh.20m.com

 

[Syed Zeeshan Haider]

in message

Format/Cells/Number/Custom/Type: 0.00" your string"

Look up Number Format Codes in HELP for more information.

I learnt Excel from help files. I did see the codes before posting but
couldn't figure out the way.

Thank you,

 

[Syed Zeeshan Haider]

Thank you very much for the information!
I really appreciate it!
--
Syed Zeeshan Haider.
http://szh.20m.com/


-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"



in message

You should be able to use a custom number format.

Examples:
#" mysymbol"
0" mysymbol"
"mysymbol "#
"mysymbol "0

When you create a custom number format you can see the displayed result

just above where you are entering the custom style.

 

[Ron Rosenfeld]

in message


I learnt Excel from help files. I did see the codes before posting but
couldn't figure out the way.

Thank you,

Yes, sometimes the HELP files are obscure. I still find it a challenge just to
find the number format codes <g>.


--ron