Questions tagged [date-format]
The date-format tag has no usage guidance.
38
questions
0
votes
1
answer
51
views
Custom abbreviated date sequence in MS word doc
This is a weird one that I would be grateful for a solution from some clever person with time to play with word macros or suchlike.
I have a word (2007) document with a few consecutive dates in ...
- 101
0
votes
1
answer
39
views
MS Word, change time format in "Open file"
I want to change the date format to ISO8601 (YYYY-MM-DD).
But I cannot find anything where it can be configured.
Currently the format is DD/MM/YYYY, but in windows - ISO8601.
Here is screenshot of my ...
- 300
0
votes
1
answer
62
views
How to stop excel from displaying 3-letter months
I am running Excel (Microsoft® Excel® for Microsoft 365 MSO Version 2211) on Windows 10.
Whenever I enter a date without a year into a cell, Excel displays the month as 3-letter abbreviations instead ...
- 177
1
vote
2
answers
474
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 ...
- 121
0
votes
1
answer
2k
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 ...
- 111
1
vote
0
answers
254
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:...
1
vote
1
answer
424
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 ...
- 113
0
votes
1
answer
137
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 ...
- 1
0
votes
0
answers
68
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 ...
- 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 ...
- 11
0
votes
1
answer
72
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","...
- 31
1
vote
1
answer
59
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 ...
- 201
0
votes
1
answer
4k
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
1
answer
1k
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 ...
- 304
0
votes
1
answer
11k
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
3
votes
1
answer
3k
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 ...
- 1,303
2
votes
1
answer
4k
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 ...
- 195
2
votes
1
answer
3k
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 ...
- 165
-1
votes
2
answers
220
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 ...
- 3
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/...
- 121
0
votes
4
answers
146
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/...
- 101
0
votes
1
answer
65
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 ...
- 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 ...
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?
- 131
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/...
- 1
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 ...
- 121
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 ...
- 3
1
vote
0
answers
495
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 ...
- 238
0
votes
1
answer
116
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)"
...
- 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
- 21
0
votes
1
answer
242
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
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 ...
- 21
33
votes
6
answers
63k
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 ...
- 6,218
8
votes
4
answers
47k
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 ...
- 2,023
1
vote
2
answers
3k
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?
- 242
3
votes
3
answers
11k
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 ...
- 349
24
votes
6
answers
15k
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 ...
- 1,094
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?
- 10.9k