Questions tagged [date-format]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
29 views

LibreOffice Calc - do not apostrophe-escape dates when opening a file

I have switched system, and the old system had locale en_DK with reasonable ISO formats, the new one currently has en_US with "imperial" stuff, bad date formats etc. While I try to figure ...
user avatar
  • 111
0 votes
1 answer
188 views

Excel won't recognise text string as a date

I'm trying to import a great many dates from an external source which contains the date field as text in the format:- Sep 23, 2021 Sep 22, 2021 etc. I want Excel to recognise these dates as being ...
user avatar
  • 11
0 votes
0 answers
70 views

How to specify output file cell format when using ssconvert --merge-to to create ODS file from multiple CSVs?

I successfully converted a series of .csv files into a single .ods spreadsheet file, but I had a minor formatting problem: all cells with date contents ended up with date and time format. Command used:...
user avatar
1 vote
1 answer
150 views

What locale does excel uses when you type ,F as date format?

My company builds reporting tools and one of the export formats is excel. As our customers come from different countries when we generate the excel file we use locale formatting to display the dates ...
user avatar
  • 113
0 votes
1 answer
33 views

text formula =TEXT(A1,"mm/dd") results to 00/dd

I am trying to convert the date to text. First, I tried =TEXT(A1,"mm/dd/yyyy") and the result is 00/dd/yyyy. From what I read in some forums, I could replace 'yyyy' with 'e' and that solved half of ...
user avatar
  • 1
0 votes
0 answers
58 views

Excel macro date formatting

I have an excel sheet that puts in the current date and time in a specific cell if a macro is ran. It formats the date and time in the format dd-mm-yyyy HH:mm. For the whole month March this worked ...
user avatar
  • 13
1 vote
1 answer
2k views

Converting Excel "JAN-20" in text format to 1/31/2020 in date format?

This question has two parts: Converting the month and year into the date Ensuring that new date is the end of each month, i.e. no individual date is provided in the original input, but the output has ...
user avatar
0 votes
1 answer
50 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","...
user avatar
1 vote
1 answer
46 views

Prevent Excel from converting 450 to a date?

Excel is converting 450 to a date when typing 450 into a cell. The date is 3/25/1901. Why is this, and how can it be prevented? I formatted the cell, but it reverts to date type every time I type in ...
user avatar
  • 201
0 votes
1 answer
3k 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&...
user avatar
2 votes
1 answer
356 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 ...
user avatar
0 votes
1 answer
9k 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
user avatar
3 votes
1 answer
2k 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 ...
user avatar
  • 1,155
2 votes
1 answer
3k 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 ...
user avatar
  • 195
2 votes
1 answer
2k 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 ...
user avatar
  • 163
-1 votes
2 answers
154 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 ...
user avatar
1 vote
2 answers
5k 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/...
user avatar
  • 121
0 votes
4 answers
131 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/...
user avatar
  • 101
0 votes
1 answer
63 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 ...
user avatar
  • 11
0 votes
1 answer
6k 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 ...
user avatar
2 votes
2 answers
6k 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?
user avatar
0 votes
1 answer
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/...
user avatar
1 vote
2 answers
3k 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 ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
1 vote
0 answers
480 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 ...
user avatar
  • 238
0 votes
1 answer
87 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)" ...
user avatar
  • 103
2 votes
1 answer
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
user avatar
  • 21
0 votes
1 answer
239 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 ...
user avatar
2 votes
1 answer
5k 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 ...
user avatar
  • 21
33 votes
6 answers
59k 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 ...
user avatar
8 votes
4 answers
44k 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 ...
user avatar
  • 1,961
1 vote
2 answers
2k 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?
user avatar
  • 242
3 votes
3 answers
10k 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 ...
user avatar
19 votes
6 answers
13k 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 ...
user avatar
  • 1,024
12 votes
2 answers
28k 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?
user avatar
  • 10.2k