Date Format

[bt2086]

How can I change date as being shown like "41087" to "June 27, 2012" on worksheet? I reference "June 27, 2012" to a different worksheet, and it is shown as "41087"....

Thanks you!

 

[Jonmo1]

Format the cell that has the formula referring to the Date as a Date instead of Number.

 

[bt2086]

It is already in Date format???

 

[Jonmo1]

OK, can you provide more information..

Which Sheet/Cell contains the actual date June 27, 2012
Which Sheet/Cell contains a formula referring to that Date
What is that formula?

 

[gary19692011]

I know I have a cheek but I have a simple ish question?
i get a U.S.A CSV file document sent to me once a week in a column it shows the date and time in some cells in this format 06/27/2012 23:13:00 PM and in some cells the format looks like this:- 06/27/2012 23:13:00. Neither of these formats I want I just what it to look like this 27/06/2012.
Ive tried all shorts of ways but they are long winded can you advise a better short route to help me convert just the date?