Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Okay, I got the money cell in cell formula to work, but now I want to do one
with a date, and can't seem to get the date to show up correctly. If I just enter the formula in the text string as &(A1) & where A1 is the date January 7, 2005, I get the numeric value of the date 38359. How do I switch the format in the calculation? Is there a way to bold is within the rest of the sentence? (This is Excel 97...I'll be getting an upgrade to Xp and 2003 in a week...) |
#2
![]() |
|||
|
|||
![]()
This will convert the 38359 to a date format in your formula:
=TEXT(A1,"mm/dd/yy")&" your cell reference here" |
#3
![]() |
|||
|
|||
![]()
Is it possible to put the date into "January 7, 2005" style, or can I only do
it numerically? "Dave O" wrote: This will convert the 38359 to a date format in your formula: =TEXT(A1,"mm/dd/yy")&" your cell reference here" |
#4
![]() |
|||
|
|||
![]()
=text(a1,"mmmm d, yyyy") & "...."
Take a look at excel's help for "Number format codes" and you'll see lots more good info. Abi wrote: Is it possible to put the date into "January 7, 2005" style, or can I only do it numerically? "Dave O" wrote: This will convert the 38359 to a date format in your formula: =TEXT(A1,"mm/dd/yy")&" your cell reference here" -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |