Date Format

bt2086

New Member
Joined
May 31, 2012
Messages
33
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!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Format the cell that has the formula referring to the Date as a Date instead of Number.
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,212,046
Messages
6,105,582
Members
447,972
Latest member
carrieann

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top