How to format date

Closed
Rach - May 2, 2012 at 05:10 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- May 10, 2012 at 10:21 AM
I copied transactions in Excel using CTRL C and CTRL V. I am trying to format the date e.g. 20/4/2011 to mm/yy (April 11) it is not formating. How do i format.

Thanks for your help.

3 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 2, 2012 at 05:58 PM
use text to column by choosing the right date format in which the data appears. Once that is done then format the column.
0
GarrettAshley
Posts
5
Registration date
Tuesday March 20, 2012
Status
Member
Last seen
May 5, 2012

May 5, 2012 at 06:09 AM
A standard date and time format string uses a single format specifier to define the text representation of a date and time value. Any date and time format string that contains more than one character, including white space, is interpreted as a custom date and time format string; for more information, see Custom Date and Time Format Strings. A standard or custom format string can be used in two ways:

To define the string that results from a formatting operation.

To define the text representation of a date and time value that can be converted to a DateTime or DateTimeOffset value by a parsing operation.

Thanks in advance.
Garrett
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
May 10, 2012 at 10:21 AM
Isn't Rach just asking how to format?

Select your cell and hit Ctrl+1 to open cell properties window. Under the Number tab you will find some options under Date. But to get more option select the botom most option. Here you can input how you would like to see your date.

mm/yy will result in: 04/11
If you want april 11 you will want to input: mmmm yy.

Best regards,
Trowa
0