How change date format.
- Thread starter ovega
- Start date
saltarazan
New member
- Joined
- Jan 18, 2013
- Messages
- 16
- Reaction score
- 0
- Points
- 0
you have two choices:
1. You have to check in which format the Date is defined in your Excel (i.e. {mm/dd/yyyy} or {mm.dd.yyyy} etc. ), you can do that by checking the cell format. so if its defined like this mm/dd/yyyy you need to change your date to 01/11/2011.
After you did that and wrote it in the cell, change the cell TYPE to "General".
2. If you want to keep your date in this format {mm.dd.yyyy} as you write it, then you have to change how the date is defined in your excel (again go to cell format and choose the desired templete in our case {mm.dd.yyyy}.
After you did that and wrote it in the cell, change the cell TYPE to "General".
Hope you understand and it works
1. You have to check in which format the Date is defined in your Excel (i.e. {mm/dd/yyyy} or {mm.dd.yyyy} etc. ), you can do that by checking the cell format. so if its defined like this mm/dd/yyyy you need to change your date to 01/11/2011.
After you did that and wrote it in the cell, change the cell TYPE to "General".
2. If you want to keep your date in this format {mm.dd.yyyy} as you write it, then you have to change how the date is defined in your excel (again go to cell format and choose the desired templete in our case {mm.dd.yyyy}.
After you did that and wrote it in the cell, change the cell TYPE to "General".
Hope you understand and it works
Kevin@Radstock
New member
- Joined
- Oct 5, 2012
- Messages
- 52
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
- Joined
- Mar 21, 2011
- Messages
- 1,960
- Reaction score
- 0
- Points
- 36
- Excel Version(s)
- O365
You can use
=YEAR(A2)*100+WEEKNUM(A2)
=YEAR(A2)*100+WEEKNUM(A2)
Kevin@Radstock
New member
- Joined
- Oct 5, 2012
- Messages
- 52
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
Hi Ovega
It is to coerce the text value to a number.
Kevin
It is to coerce the text value to a number.
Kevin