Auto Format Date w/ Superscript Foornote

[jbkline]

Hi Everyone!

So I am trying to have a date that has a corresponding footnote come together within the same cell, both are currently in their own columns. The outlook would be something like "12/31/2012 (1)" where the (1) would be in superscript. I know that I can do this manually by going into each individual cell, highlighting the footnote and making it superscript but this is not very efficient. I tried using the following formula "=CONCATENATE(TEXT(D8,"m/d/yy"),E8)" but when i do this I get "6/4/12-1" as my output.

Does anyone know how to make the footnote superscript, or a smaller font size and shifted to Top Align, while leaving the date's format as is? Any advice would be much appreciated!

Thanks guys!

-jbkline </SPAN>

 

[Sal Paradise]

Hi Everyone!

So I am trying to have a date that has a corresponding footnote come together within the same cell, both are currently in their own columns. The outlook would be something like "12/31/2012 (1)" where the (1) would be in superscript. I know that I can do this manually by going into each individual cell, highlighting the footnote and making it superscript but this is not very efficient. I tried using the following formula "=CONCATENATE(TEXT(D8,"m/d/yy"),E8)" but when i do this I get "6/4/12-1" as my output.

Does anyone know how to make the footnote superscript, or a smaller font size and shifted to Top Align, while leaving the date's format as is? Any advice would be much appreciated!

Thanks guys!

-jbkline </SPAN>

You cannot format text differently using formulas. You can do it manually or with VBA only.