View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do I add text in the same cell with a fomula?


=yourformula & "*"

But you would not be able to use that cell as a reference in another formula
because the cell contents are Text and not numeric to be used in further
calculations.

If you need that cell to remain numeric use a custom format of

#,##0.00 "*"


Gord Dibben MS Excel MVP


On Sat, 18 Aug 2007 13:16:00 -0700, twb111
wrote:

I want to add a footnote reference (*) in the same cell with a formula. I
want the cell formula results to look this.

368 *

Thanks,

Tom