Text in custom format not showing up in cell results ... (?)

  • Thread starter Thread starter StargateFan
  • Start date Start date
S

StargateFan

Wonder what I'm doing wrong this time ... ? <g> I've used this
technique so many times before but today it isn't working.

In cell B2 I have this formula: =(B1*16)
The custom format for this cell is, instead of just number: @" units"
All I get in B2 is a number, 32 in this case, but not " units" after
it.

What am I missing pls?

Thanks! :oD
 
Hi,

You can use following:-
=(B1*16)&" Units"
For custom format, you should use following format.
?" Units"
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
###" units"
Click to expand...

Hi, thanks. Will try this again. I keep running into this problem so
I have to remember that @ is for text is ### is for numbers. Makes
sense. Never was conscious of this before, I guess.

Will try it out
 
Back
Top