Formulas

  • Thread starter Thread starter Sarah74
  • Start date Start date
S

Sarah74

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".
 
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:)
 
="Cash: "&TEXT(A1,"$0.00")

Sarah74 said:
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:)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula required (2nd time) 6
Total formula 1
Auto-adjusting Formulas 1
PLEASE HELP??? copy every other cell value to a range of cells 3
Combine VLOOKUP and HLOOKUP's capabilities 9
Another Lookup Question 3
Aging Formula 5
Excel Need aid in Excel Formulas 3

Back
Top