How to format date
Closed
Rach
-
May 2, 2012 at 05:10 PM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- How to format date
- How to change date format in excel - Guide
- Describe the basic formatting of html documents layout. - Articles
- How to format write protected usb - Guide
- Samsung mobile format code - Guide
- How to change whatsapp time to 12 hour format - Guide
3 replies
rizvisa1
May 2, 2012 at 05:58 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
May 5, 2012 at 06:09 AM
- 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
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
May 10, 2012 at 10:21 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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