How to format date
Closed
Rach
-
May 2, 2012 at 05:10 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2012 at 10:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 10, 2012 at 10:21 AM
Related:
- How to format date
- How to change date format in excel - Guide
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Swissknife format - Download - Storage
- Marksheet format in excel - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2012 at 05:58 PM
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.
GarrettAshley
Posts
5
Registration date
Tuesday March 20, 2012
Status
Member
Last seen
May 5, 2012
May 5, 2012 at 06:09 AM
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 10, 2012 at 10:21 AM
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
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
