Formulas
 

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".

Formulas
 

Try this
Change A1 to your needs
="Balance Sheet"&TEXT(A1," m/d/yyyy")

"Sarah74" wrote:

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".

Formulas
 

hi,
try this...
="Balance Sheet AT " & text(A1,"mm/dd/yy")

regards
FSt1

"Sarah74" wrote:

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".

Formulas
 

You guys are great. That worked...thank you. Since that was so easy for you
to figure out, is there a way to do with with currency too? ="Cash: $" &
cell that has currency amount.

Thanks again:)

"FSt1" wrote:

hi,
try this...
="Balance Sheet AT " & text(A1,"mm/dd/yy")

regards
FSt1

"Sarah74" wrote:

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".

Formulas
 

="Cash: "&TEXT(A1,"$0.00")

"Sarah74" wrote:

You guys are great. That worked...thank you. Since that was so easy for you
to figure out, is there a way to do with with currency too? ="Cash: $" &
cell that has currency amount.

Thanks again:)

"FSt1" wrote:

hi,
try this...
="Balance Sheet AT " & text(A1,"mm/dd/yy")

regards
FSt1

"Sarah74" wrote:

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".

Formulas
 

hi
mike beat me to it. read up on the text function.

regards
FSt1

"Sarah74" wrote:

You guys are great. That worked...thank you. Since that was so easy for you
to figure out, is there a way to do with with currency too? ="Cash: $" &
cell that has currency amount.

Thanks again:)

"FSt1" wrote:

hi,
try this...
="Balance Sheet AT " & text(A1,"mm/dd/yy")

regards
FSt1

"Sarah74" wrote:

I am trying to do a formula where I can start with ="Balance Sheet at "&cell
that contains date so it ends up being "Balance Sheet at 6/30/08" and the
cell that includes the date is formatted as a date cell but when it comes out
as "Balance Sheet at 39538".