One mo

=Current Situation: " & text('sheet1'!a1,"mm/dd/yyyy")



wrote:

Hi guys. I am hoping you can help. I am having trouble getting the Date
formatting to properly respond in Excel (2003).

1. Cell A1 in 'sheet1' displays the date "09/02/2006" The formatting is
set to mm/dd/yyyy

2. In Cell A1 'sheet2' I would like to display the sentence "Current
Situation: 09/02/2006"
- The text should remain constant with the date changing to reflect
the date entered in cell A1 'sheet1'
- My attempted formula was: ="Current Situation: "&'sheet1'!A1
- The end result of this was: "Current Situation: 38952" (without
the quotation marks)

3. In an attempt to isolate my problem, I tried the cell reference
without the constant text and the output was still incorrect.
- In this instance cell A1 "sheet2" formula was: ='sheet1'!A1
- this yielded the response: 38952

How do I get this to properly display. The formatting for both sheets
is mm/dd/yyyy. I am somewhat new to excel so please bare with me but I
suspect the trouble is in my formatting.

Thanks in advance.

Nate

--

Dave Peterson