Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |