Excel dates formats

0

When users enter a date in Excel using this format 19.03.2013, I need the cell to automatically change the format to Wed 19 Mar'14.

I copied dates(column C & D) from MS Project. I am getting error message when trying to use the formula DATEVALUE.

Maybe while copying the dates from MS Project Excel is considering the date as text and thus I am getting error message.

Any advice?

PS: sorry, I am unable to add image in my post.

haneesh

Posted 2014-03-19T07:04:35.603

Reputation: 3

Answers

1

Check here...This might help you...

Steps:

  1. Select the cells you want to format.
  2. Press CTRL+1.
  3. In the Format Cells box, click the Number tab.
  4. In the Category list, click Date.
  5. Under Type, pick a date format. Your format will preview in the Sample box with the first date in your data. Note: Date formats that begin with an asterisk (*) will change if you change the regional date and time settings in Control Panel. Formats without an asterisk won’t change.
  6. If you want to use a date format based on how another language displays dates, pick the language under Locale (location),

Vysakh

Posted 2014-03-19T07:04:35.603

Reputation: 178

You are welcome... Feel free to visit www.systemadminguide.wordpress.com for Server Tech stuffs – Vysakh – 2014-03-19T07:32:38.450

Please include the relevant details in your answer. Otherwise, you might as well link LMGTFY. – Daniel B – 2014-03-19T07:36:18.093

@DanielB, Relevant details in the sense?? The correct answer is there in the link.. – Vysakh – 2014-03-19T07:38:20.170

How to answer: “Always quote the most relevant part of an important link, in case the target site is unreachable or goes permanently offline.” – Daniel B – 2014-03-19T07:40:42.623

@DanielB, Done...Hope that's enough.. – Vysakh – 2014-03-19T07:44:17.130

Asked: 2014-03-19T07:04:35.603

Viewed: 522 times

Active: 2016-05-10T12:47:25.927