Questions tagged [date-format]

The tag has no usage guidance.

0
votes
1answer
26 views

Excel won't import date string as date serial number. Maybe Locale or text file encoding issue

I have a spreadsheet that uses a text file with a date string as the first field. I have no control over the format of the file: "Time_Stamp","User_Name","Host_Name" "31 Jan 2018 8:10:20 PM","AMG","...
0
votes
1answer
338 views

What is wrong with my concatenate formula for date in excel?

I've been in this trouble for some times. I have "Oxford" in cell A1 and "02 January 2019" in cell B1 and I want to merge these two cells separated with a comma and single space. I've tried =A1&...
2
votes
1answer
53 views

Excel requires dates to be typed in American format

In order to type a literal date into an Excel cell, I currently have to do it in the American format (mm/dd/yyyy). This is unacceptable. How can I have it such that Excel will correctly recognise ...
0
votes
0answers
543 views

Outlook 2013: How do group by received date and display received time?

I am using Outlook 2013. By default it groups based on the received date of Today, yesterday, days of the week, last week which really includes everything prior. Then the received column shows m/dd/...
0
votes
1answer
4k views

Custom Date Format in Microsoft Word 2016

I would like to be able to insert a date format in Microsoft Word that is not included in the list of existing formats. Specifically, I want this format: DD th day of Month, YYYY
1
vote
1answer
1k views

How to set date format in Google Chrome 60 in Windows 10

One of the web-mail interfaces I'm using is SmarterMail. When I open the SmarterMail message list in my Google Chrome in Windows, message dates are formatted as d.M.yyyy: for instance, Jul-20, 2017 is ...
2
votes
1answer
2k views

Have a slash-separated date recognized by Excel?

I received an Excel file with a column filled with slash-separated dates in a given column. The dates isn't directly recognized by Excel as being so. Thus, it is not sorted correctly when I use the ...
2
votes
1answer
1k views

How to change date format in file name using bash/linux?

Is there an easy way to change in a linux console the date format in a file name? Eg. I have a bunch of files which contain a date (DD-MM-YYYY) in the file name like: example_20-08-2016.pdf and I ...
-1
votes
2answers
64 views

How can I open a specific sheet named after a month?

I have a bunch of Month Tabs What is one way to open a specific one with VBA? I tried using this snippet: Private Sub Workbook_Open() Dim ws As Worksheet Dim mnth As String, dte As String, mday As ...
1
vote
2answers
4k views

Convert date format 5/29/2014 12:00:00 AM to 5/29/2014

I have a column with dates in the following format, a timestamp "5/29/2014 12:00:00 AM" -- I've tried all sorts of things to try to get all of them to trim the time part and end up with only "5/29/...
0
votes
4answers
121 views

Excel: Cannot get Custom Number Format to work for specific date and time

I've been going over this for a while and for the specific date + time format I have, I cannot get the Custom Number Format to pick the date up properly. I have these dates (several examples): 6/21/...
0
votes
1answer
47 views

Day of week display for windows 7 gone? [duplicate]

I can no longer see the day of the week by hovering over the date on my Dell latitude using windows 7. Going to Control panel/ region & Language / Formats +/- Additional settings doesn't give a ...
0
votes
1answer
4k views

Excel VBA Date format: Hyphen as separator gives wierd substitution result

Excel 2007. I want a macro to put today's date in the current cell formatted as dd-mmm-yy, e.g. 30-Oct-14. The code I have is simple : 'ActiveCell.Value = Format(Now(), "dd-mmm-yy")' For some ...
2
votes
2answers
4k views

change date format on Win 8.1 lock screen

Is it possilble to change the date format on the Win8.1 lock screen from dayofweek, month day to dayofweek, day month?
0
votes
1answer
2k views

Excel date format transposing numbers

How to stop excel changing date format? I type in 05/11/2014 as in fifth November and it displays 11 May 2014 in the cell Yet in the cell content line at the top of the sheet it still displays 05/...
1
vote
2answers
2k views

How to use a space in date format section of annotate-output?

I try to use annotate-output (part of devscripts package), to prefix outputs of a script with date and some extra info. First parameter can be a format string passed to date. I want to include a space ...
0
votes
1answer
419 views

Excel dates formats

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 ...
1
vote
0answers
464 views

Change date language (months, week days) without changing system locale in Windows 7

I have Russian system locale in my Windows 7 (set in CP, Region and Language, Formats, Russian). I'd like to keep it since some Russian programs I need don't work correctly under English locale. But ...
0
votes
1answer
81 views

One hour too much in date formatting using date(1)

If I execute the following commands in the terminal start=$(date +%s) # wait a few seconds … end=$(date +%s) time=$(dc <<< "$end $start -p") echo "$time" echo "$(date -jr $time +%H:%M:%S)" ...
2
votes
1answer
2k views

Enforcing format input into a cell

I need my spreadsheet to only allow users to input in the format hh.mm/hh.mm for their working pattern e.g. someone works 12.5 hours in a 37 hour week would only be allowed to be input as 12.50/37.00
0
votes
1answer
219 views

How to format a date in Calc?

When I enter 09/02/2013 00:00:00 in a cell in Windows 7, the cell displays 02.09.2013 00:00. I have specified the proper Format code in Format Cells: In Windows XP, the outcome is as expected. The ...
2
votes
1answer
4k views

Open Office Calc time to decimal

My task is very simple but I cannot figure out how to do it. I am setting up a time sheet in OpenOffice Calc with 3 columns. The first two columns are Time formatted columns that represent my start ...
27
votes
6answers
37k views

How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?

I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012. I tried scrolling through the different types of ...
8
votes
4answers
37k views

Custom Date Format in MS Word 2010

I have a date field in a Word document which was created from a template included with Microsoft Word 2010. The default setting for this field is to display only two places of the current year. I ...
1
vote
1answer
1k views

How can I convert Gregorian date to Jewish date using Excel?

How can I convert a Gregorian date to a Jewish date using Excel 2007?
3
votes
3answers
7k views

Insert current week number in Microsoft Word

Is there any way in MS Word to insert current week number? I need to make a template for the weekly report, and I'd like the week number field to be filled in automatically... What I need is something ...
8
votes
4answers
7k views

Change the format of the date column in Thunderbird

I want to change the format of the "Date"-column in the message list in Thunderbird. For mails from today, I want to display only the time, not the date. For mails from before today, I want to ...
11
votes
2answers
20k views

How to change Windows 7 date format?

Is it possible to configure Windows 7 to use YYYY-MM-DD instead of DD/MM/YYYY as the date format? How? Where?