The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
38 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 ...
0
votes
1answer
60 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
48 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 ...
1
vote
2answers
352 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 ...
1
vote
0answers
193 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
43 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
432 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
123 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 ...
1
vote
2answers
1k 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 ...
10
votes
3answers
9k 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 ...
3
votes
4answers
12k 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
577 views

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

How can I convert a Georgian date to a Jewish date using Excel 2007?
3
votes
3answers
2k 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 ...
4
votes
1answer
2k views

Change the format of the date column in Thunderbird

I want to change the format of the "Date"-column in the messagelist in Thunderbird. For mails from today, I want to display only the time, not the date. For mails from before today, I want to ...
5
votes
2answers
7k 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?