The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
82 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
154 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
40 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
268 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
105 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 ...
9
votes
2answers
7k 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 ...
2
votes
3answers
10k 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
534 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
6k 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?