The tag has no usage guidance.

learn more… | top users | synonyms

-1
votes
2answers
24 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 ...
0
votes
2answers
105 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
79 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
34 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
1k 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
1k 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
470 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
1k 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
123 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
365 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
49 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
1k 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
169 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
3k 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 ...
16
votes
5answers
22k 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 ...
5
votes
4answers
23k 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
780 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
4k 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 ...
5
votes
2answers
3k 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 ...
6
votes
2answers
10k 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?