Computer Support Forum

Date format using space as date separator rather than forward slash!

Question: Date format using space as date separator rather than forward slash!

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting) didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?

Thanks
Steven

Relevance 100%
Preferred Solution: Date format using space as date separator rather than forward slash!

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Date format using space as date separator rather than forward slash!

Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS

9 more replies
Relevance 87%

Having a brain drain at the moment.
How do I get date to show as 17/7/11?

Using Excel 2003

Pedro
 

Answer:Solved: Show forward slash rather than minus sign in excel date

10 more replies
Relevance 104.96%

Since installing Windows 10 - previously on Windows 7 - all dates in Excel have turned into the American date format i.e. previously 12/08/15 in a cell displayed as 12th August 2015. Now it displays correctly but the cell contents have changed, so, in previous example, the cell now contains 08/12/15. How can I put this right? I have gone into anything I could see re language and have ensured it is English (United Kingdom) but this hasn't made any difference.

Answer:Windows 10 has turned my British date format in Excel into the American date format. How can I get it to turn back?

Freeeeeeeeeeeeedom!

10 more replies
Relevance 98.4%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

More replies
Relevance 98.4%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

Answer:Taskbar Time / Date area quit expanding to fit desired date format

I had a similar problem which has been greatly ameliorated thanks to a kind respondant - see https://www.tenforums.com/installatio...-new-post.html

1 more replies
Relevance 98.4%

Hi! Does anyone know what is the format of the date in the field "(battery) Manufacture Date" informed by Lenovo Vantage (Hardware Configuration > Energy)? It seems not to follow Windows setting. In my case, it is set to Brazilian Portuguese DD/MM/YYYY, but there is not a leading "0" in the returned value (see attached image). Does it really disregard the Windows setting and presents it in a fixed format (maybe American English)? When was my battery manufactured (Oct. 07 or July 10)?Thanks in advance.  

More replies
Relevance 97.99%

How could I set Regional settings formats to UK and change date separator from slash to point? (23.03.2011) Windows XP had Customize Regional options to change Date separator but it's missing on W7. Thanks!

Answer:How to change date separator

Go to the Control panel and select Region and Language
Under format select English UK from the pull down menu
Then select additional settings
Then the Date tab
The next to Short date select the pull down menu and you will find the format you want dd.M.yy
I hope this helps.

4 more replies
Relevance 97.17%

Is it possible to add space(s) between the date and the time?
i.e. instead of 19/06/2012 16:55, I'd prefer: 19/06/2012 *** 16:55

(* = Space. The editor is removing the spaces).

Thank you.
 

More replies
Relevance 97.17%

Eg: In the below table (Excel) right now date is numeric want to convert them to DATE format Date of Birth Sex Date of diagnosis1 1/07/41 F 21.02.092 12/06/90 M 2/24/22614 1/07/62 M 11/02/095 1/07/48 F 26.05.096 1/07/39 F 11.02.097 1/07/76 F 2.05.098 1/07/60 F 30.05.099 1/07/80 F 1.03.0911 1/07/56 F 22.03.0914 1/07/65 F 22.02.0916 1/07/74 M 22.02.0917 1/07/67 F 24.03.0919 1/07/33 M 25.02.0920 1/07/45 F 21.03.09

Answer:Convert multiple date entries to DATE format

Whoever wrote the file couldn't even decide on a standard date format. Needs two routines. I prefer to normalize to yyyy/mm/dd.

7 more replies
Relevance 91.84%

Hello allIs there anyway that I can type in a date like: 010199 and it then gets recognized as a date format and displays it as 01-01-1999 ?I can do it the other way around, if I type 01-01-1999 and have modified the date format to be ddmmyy, it works, but somehow it doesnt work the other way around.Any ideas for this? I know it is possible to make it happen by using another column and the number 010199 then gets converted to 01-01-1999, but I need this to be done automaticly (and with no macros)Thanks in advance/Jacob

Answer:Date format when typing the date?

Where are you typing this address - presumably in an Excel column?

6 more replies
Relevance 84.05%

Hi all,My outlook express 6, when i forward my email the date inside the original email date is changing today date. Actually this email received by last two weeks ago. If we forward the existing email inside sent items it have two dates, one is the old email's incoming date and another one is our current date. But all two dates is changing the current today right now date time. So strange! Is anyone have an idea please?Best Regards,Horace

Answer:Outlook express forward today date

horacetrever, suspect that what you need to do is c/p the fwd. into a new mail and send it rather than simply fwd. it. If you desire, put the original date in the new title. You will have today's date on the mail, but you can show the original date within the body of the mail if you'd rather. It also gives you the option to get rid of that annoying chain of fwd. addresses if you wish.HTHEd in Texas

3 more replies
Relevance 82.82%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 5211 MB; D: Total - 36294 MB, Free - 8687 MB;
Motherboard: ECS, G41T-M
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

Hi All
Im using the attached vba code and would like to use the "title" format function to show the date of the day in the User Form, is it possible and is there any help on this matter.

Thanks in advance
Rusty
 

More replies
Relevance 82.41%

When I wake my PC from sleep or/and hibernation the date and time always jump forward. Sometimes months.

Here is what I've tried to fix it:-
Checked time zone and region settings.
Turn off hibernation via command line with >powercfg/h on
Turn on hibernation via command line with>powercfg/h off
Several different combinations of setting in the power options.
Checked Windows Time service is set to automatic and windows is set to sync to time.windows.com.
Changed bios battery. (Bios time is always right.)
Installed a 3rd party time server sync tool (Network Time Synchronization).
Fresh install of Windows 10 pro.
Updated all drivers to latest versions.
Updated firmware of Nvidia card.
Updated motherboard bios to latest version.

Another issue is that the login window will sometimes freeze after the PC wakes with the wrong time and date displayed sometimes with a blue background or sometimes with the lock screen wallpaper. The PC has to be manually restarted when this happens.

I think this may be a problem with RAM but the timings settings are double dutch to me.

I have found loads of post with simular problems but none that have provided me with the answer to my problem.

The PC runs flawlessly otherwise so I'm pretty sure that faulty hardware is not the problem.

Any help please.

Answer:Time/Date jumps forward when PC wakes from Hibernation or Sleep.

Are you using a computer that is set up for Dual Boot, so that you can use another OS? You need to put down in "My System Spec's" if you are using Home or Pro version of Windows. Are you able to sync with the Time Server? Follow the info at this link for checking NTP settings. windows - How can I check a system's current NTP configuration? - Super User

If it is showing "UTC" time, the Time Sync Tool can help. It needs to be corrected without the tool. Make sure you are using the following steps when checking the time.

Press “Windows+X” and click on “control panel”.On the left hand side click on “clock, language and region”.Click on “change time zone”.And then click on the tab “internet time” and click on “change settings”.Check the box “synchronize with an internet time server” and also select the option “time.windows.com” from the drop down and click on “ok” and check if the issue persists.

8 more replies
Relevance 81.18%

Windows repeatedly asks me to update with the little yellow exclamation mark in the tray but it always fails and then keeps asking over and over again. It's trying to update something I don't even use I think PowerPoint or something; I had the option off at one point for those programs so it wouldn't keep asking but then a message pops up saying are you sure you want to leave these off you might need them.

Any ideas on how to get past this?
 

Answer:Windows Update...date...date...date....

Have a look at this link and see if it helps.

http://support.microsoft.com/kb/910339/en-us
 

1 more replies
Relevance 80.77%

I am setting up a spreadsheet for the year and want to use it year over year. I have the cell set up with the date (1/1/2011) with a format of d so that it displays the date as Sat, 1/2/2011 - Sun, etc. Since I want to use this year after year with minimal work and I want to highlight the cells that are equal to Sat and Sun, how would I set up that formula. I tried the basic =A1="Sat" and without quotes but it just returns #NAME. I know working with dates in formulas is different but can't figure out what I need to use.
 

Answer:Solved: Excel 2007: conditional format when date displayed as format d

8 more replies
Relevance 79.54%

I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected.Here is my formula: =A2&(LEFT(C2,3))&LEFT(B2,3)&LEFT(F2,1)where the cell A2 contains the date 11/23/1982However, in the results, it is appearing as 30278.The most frustrating part is I did the same formula in another spreadsheet and it worked as expected! The dates in that spreadsheet showed in the date format. Unfortunately, I did not save the other spreadsheet since that was just a draft to get the identifier.message edited by luthientinuviel

Answer:Formula is returning the text format instead of date format

Untested...=TEXT(A2,"m/d/y") & the rest of your stuffor=DATE(MONTH(A2)&"/"&DAY(A2)&"/"&YEAR(A2)) & the rest of your stuffClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

6 more replies
Relevance 78.31%

As above, I recently upgraded to XP from ME and since then the date format in the Received column of Outlook 2000 is in US format while in the Control Panel, everything is set correctly to the UK format.

Is there any way of forcing the issue in Outlook to make it behave as per the Control Panel?

Cheers all.
 

Answer:XP is on UK date format, Outlook 2000 is on US format

Hi Simes

After a cursory look through Outlook,
How does the time display in Outlook 2000,
Tools > Options > Calendar tab > Time Zone?
 

3 more replies
Relevance 78.31%

in spread sheet if I format a cell as English uk date format dd/mm/yy I have to input data as mm/dd/yy and it shows it as uk format but if I input it as uk format it does not. All my older version spread sheets and accounts when opened with excel 10 give me wrong format. I have checked that the transition mormula boxes are unchecked

Answer:date format in excel 10 will not show uk format dd/mm/yy

It is not an Excel issue.I believe what you need to do is change the System Date Format, it is probably set for US and you need to change to UK.Look here for instructions on changing the System Date:http://windows.microsoft.com/en-us/...This is for Win 7, but Win 10 should be similar.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

3 more replies
Relevance 77.9%

I got a Refurbished Dell Latitude D600 Laptop from ebay yesterday on Tuesday, September 26th 2017, It had Intel Pentium M (Non-Centrino) and Windows XP Pro SP3, but when i boot it up, it resets to The Default BIOS Date, can someone help me?

Answer:Dell Latitude D600 Current Date Resets to The Default BIOS Date

The coin cell battery on the motherboard that keeps time while the system is powered off is probably dead.  Not too surprising given that the D600 is about 15 years old at this point.  If you open the system up, it should be easy to find, so just note the type of battery, e.g. CR2032, and then buy that type of battery at any grocery/convenience store.  Should only be about $2-3.

2 more replies
Relevance 77.9%

First the background: We are gradually deploying Office 2007, but not everyone in the agency has it. I have both 2003 and 2007 installed on my system, but I do my work in 2003, and none of our databases have actually been converted to 2007 format (at least, none that I work with). There are occasionally people who use 2007 when viewing databases, but I don't know if any of the people who are working in this particular database are using 2007. The problem is reproducible in 2003 and so I've been trying to fix it here. The query behind the problem report used to work. It has been a problem for several months (it is run monthly, and every month for the past five they've had problems with it) and I've finally gotten to the root of the actual issue.

The purpose of the report is to generate invoice for outstanding loans. The DateNextPayment is a calculated field based on the payment plan for the loan. It is calculated using a function in the query named qryGetSitesDDInvoices1. This is the function that is called (I did not write this function, I'm supporting this db long after the original writer has left):
Code:
Function DateNextPayment(PaymentSchedule As String, DateFirstPayment As Date, Balance As Currency)

On Error GoTo Handle_err

Dim Date1 As Date
Dim Date2 As Date
Dim Date3 As Date
Dim NextQtrDate As Date

'The code adds one month to datenextpayment at start of each month. Or yearly or weekly

... Read more

Answer:Solved: Date Parameter Failing in Query from calculated date field using DateValue Ac

16 more replies
Relevance 77.9%

Help! I am using a Seagate Central 4TB NAS drive attached to my router via Ethernet. It has been working fine so far for all kinds of file activities. But whenever I modify a file in one of its folders, the creation date for the file also updates and is
changed to the same time as the new modified date.
Maybe relevant details:
I can move/copy folders to the drive and they maintain their created dates.
It happens for both a private user share on the NAS and for the Public share on it.
It happens for at least image files and text files.
I am able to edit files across two computers on the network just fine, the create date stays the same.
This happens from a new Windows 10 machine and Vista machine both.
I notice sometimes the date created seems to stay same until I access the file the next time.
I can't update the NAS firmware because of error.

If it could be a permissions problem, I have been unable to change it from:
Everyone: Special Permissions only
nobody (Unix Group\nobody): Special Permissions only
nogroup (Unix Group\nogroup): Special Permissions only
(Those were there automatically, they are not something I manually put there. I get "Access is denied" whenever try to add permissions or change ownership.)

I have Googled many phrases of this problem far and wide and come up with nothing. I really need to save the original create date because that's how I sort them in programs like Windows Photo Gallery or Picasa. Does anyone know what's goin... Read more

More replies
Relevance 77.9%

The title is self-explanatory. So far, I found a software that is able to change this called 'Attribute Changer' but it only changes the date modified in the folder and, when you go into the actual word application > file > info, the date created and modified are not changed. Any help would be greatly appreciated! Thank you!
 

Answer:Changing 'date created' and 'date modified' in Microsoft Word 2013

7 more replies
Relevance 77.9%

It looks like the 31 March deadline for the latest Edge promotions is the date of invoice rather than the date of order. Given Lenovo's reported long build time and slow delivery (= late invoice), I suspect that ording now from the Lenovo web site will see an invoice date outside the qualifying period. Even a dealer who says he can 'get one in' may not deliver and invoice until April or beyond. I think the only option is to find a dealer who unequivocally has current stock.Can anyone shed any light on the likely position. I do, though, wonder about trying to take advantage of Lenovo Cashback at all, given the horror stories reported here.

Answer:Edge 31 March promotion deadline - order date or invoice date?

My experience with cashback is a deathly silence from Lenovo to emails asking for progress on the cash or even recognition that there has been a registration for cashback...Currently considering giving Lenovo some publicity on the matter.Unless you have a lot of time to possibly get no where I would steer clear of the alleged cashback scheme...

1 more replies
Relevance 77.9%

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

Answer:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

16 more replies
Relevance 77.9%

Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the specified range ... but how do I know what the Search is doing?

Can't trust it... !

Answer:File search (by date range) displays incorrect Mod Date in results

That is very strange. Bump for a possible solution, since I can't think of one off the top of my head.

1 more replies
Relevance 77.9%

Hello.
I'd like to see Long Date and Long Time in my System Tray instead of Short Date and Short Time. 
But due to some restrictions connected with my work I can not modify Short Date & Short Time to look how I want them to look in System Tray.
So basically I need Windows to show what is set as Long Date & Long Time in System Tray instead of showing Short ones.

Is it possible? Maybe some registry tweaks?

Answer:How to display Long Date in System Tray (without modifying Short Date)?

Hi,
There is no workaround to display the Long Date in taskbar without modifying the Short Date parameter.Ivan-Liu
TechNet Community Support

8 more replies
Relevance 77.9%

After running a large update of windows on May 18 I found that ALL my files in ALL my folders are showing a Date Modified of May 18 2013. Can't find a similar report of this problem. Any ideas?
Using Windows 7 Professional 64-bit

Answer:File Date Modified reset to today's date after windows Udate

Would this help? enter link description here

1 more replies
Relevance 77.9%

hello to everybody

I need batch code to check if date is modified in three files and that date should be compared with current date (%date%).If so,do some job,otherwise quit (exit /b)

I found a bunch of solutions but what troubles me is date format.
On my machine it is dd.mm.yyyy

Thanks in advance.
 

Answer:Solved: batch to compare file modified date with current date

10 more replies
Relevance 77.9%

I forgot my new mobile password.Also i remove battery then time setting is now incorrect.I try 5-6 type to set password

Answer:I forgoet my scree lock password?Also i remove battery ow date setting is not current date?

hard reset your phone using following steps :-
1. Turn off your Windows Phone. Use power button to power off the phone.
2. Press and hold Volume down key and connect the charger to phone. You will see a big exclamation mark on the screen.
3. Press these keys one after another in the same sequence. Volume Up, Volume Down, Power, Volume Down.
4. You will see the phone reset and boot normally. You will see wheel gears working on the screen. It will take few minutes.
Your phone will be reset to factory settings and you need to set up the phone again.
Or try to reset phone's setting if it is connected to Wi-Fi or data is enable through your account.

more replies
Relevance 77.49%

Hi all,I need dos command to compare the file creation date and the modified date.My scenario is,If user inputs the folder path to the batch file, i have to provide the file list (which are under sub folders of the given folder) ,which do ot have creation date and modified date as same.can anyone help in thisThanksVanisree

Answer:Dos command to compare file creation date and modified date

You need a CMD.EXE Command Prompt solution, XP does not have MS-DOShttp://ss64.com/nt/ARM Devices are the future, great British Design !

2 more replies
Relevance 77.49%

I have a field that reads 2009-12-30-15.42.22.81298 as text. i want to make in be a date of 12/30/2009 15:42:23 and ignore the milliseconds. Is this possible?

Thanks
Ted
 

Answer:Converting complex date text fields into date or numbers

Ted, what software are you talking about?
Are there always 8 values in the date part?
 

3 more replies
Relevance 77.49%

I'm working on a spreadsheet that lists monthly recurring expenses. I have one cell on the sheet listing the current date (using the "=Now()" formula), but I'd like to have the other cells change at certain times throughout the month.

For example, if one cell currently says "April-15", when the actual date reads "April-16", the respective cell would change to "June-15". This way, whenever the spreadsheet is viewed the next recurring payment date will be seen.

I know this is the wrong tool for something like this - I'm using SharePoint at the office with a calendar list with workflows that shoot off emails in a much better put together format - but this is just for home use and I'd like to keep it all in one document if possible.

Any ideas or suggestions would be greatly appreciated. Thanks in advance.
 

Answer:Excel 2010: Cell Date Change with Current Date

The way I read it was that you have fixed recurring payment dates, so you just want to know the next date based on the day today. Hope the attached might assist.
You need to list the payment dates somewhere and then the formula looks up the next date. You might want to look up today plus 1 (or something) to reflect the fact that if the next payment date is today, there's a good chance you'll not get any unplanned payments on that run.
 

1 more replies
Relevance 77.49%

Somehow the date on one of my old Excel files has turned from 1999-10-04 (i.e. October 4, 1999) to 4617-04-11. How can I change all the rest of the incorrect dates back to what they should be? This is the only date that I can confirm. And I have no idea what the rest of all the dates should be on this spreadsheet. TIA.

Answer:Excel date problem - to convert incorrect date to original

I have no idea what the rest of all the dates should be on this spreadsheetThen how do you purpose to change them, when you don't know what year they are supposed to be?Somehow the date on one of my old Excel filesAny Macros running that may have in some way impacted the dates?How is the data stored? As Text or as a Date?MIKEhttp://www.skeptic.com/

5 more replies
Relevance 77.49%

I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th for each month of the year; 15-Jan, 30-Jan, 15-Feb, 28-Feb, ... 30-Dec.Cell C1 needs to return the number from A1:A24 based upon today's date compared to the date in B1:B24.For example today is 08/21/15, what number should be returned in Cell C1. It should be 15 as 08/21 is less than 30-Aug.message edited by jmichels

Answer:Return a number based on today's date compared another date.

Try this formula, see how it work for you:=INDEX(A1:B24,MATCH(TODAY(),B1:B24,1),1)This will work for most dates, but errors out if the Date is 01/14/15 or less.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 77.49%

Hi all,I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).Date Day Activity Income 02/01/2012 Monday Work (8) 48.00 02/01/2012 HMOT 5.00 02/01/2012 Peter Taylor 134024855 HMOT 5.00 02/01/2012 Susan Taylor 134023422 HMOT 5.00 02/01/2012 Steve Davy 13402737404/01/2012 Wednesday Work (8) 48.00 04/01/2012 HMOT 5.00 04/01/2012 Tom Thompson 134027410 HMOT 5.00 04/01/2012 John Ackroyd 134025131 HMOT 5.00 04/01/2012 Aftab Ilahi 134022546Above is an example of the sheet.In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.Please feel free if that doesn't make sense to ask questions.Thanks in advance.

Answer:acro to input date and print based on date range

Below is the code I have for a macro which I can't seem to get to work right.Thanks.
Public Sub PrintMonth()
On Error GoTo Proc_Error

Dim wksCurr As Worksheet
Dim rngTarget As Range

Dim strInput As String
Dim datInput As Date
Dim datStart As Date
Dim datEnd As Date

strInput = InputBox("input start date for month", "Enter date")
If strInput > "" Then
datInput = CDate(strInput)
If datInput > 0 Then
Set wksCurr = ActiveSheet
Set rngTarget = wksCurr.Columns(4)
datStart = WorksheetFunction.EoMonth(datInput, -1) + 1
datEnd = WorksheetFunction.EoMonth(datInput, 0) + 1
With wksCurr
If .AutoFilterMode Then
.AutoFilterMode = False
End If
.UsedRange.AutoFilter Field:=rngTarget.Column, Criteria1:=">=" & datStart, _
Operator:=xlAnd, Criteria2:="<" & datEnd
.PrintOut
.AutoFilterMode = False
End With

Set rngTarget = Nothing
Set rngDate = Nothing
Set wksCurr = Nothing
End If
End If

Proc_Exit:

Exit Sub

Proc_Error:

Select Case Err
Case Else
MsgBox "Error " & CStr(Err) & ": " & Err.Description
Resume Proc_Exit
End Select

Exit Sub

End Sub

3 more replies
Relevance 77.08%
Relevance 77.08%

My Forward Slash button does this on this Firefox browser \ but in Eudora, it appears as a Y with two cross marks on the bottom of the Y.

I've rebooted the system, also shut down Eudora, restarted that, but it continues to do this. At the first, rebooting did the trick, but not now. Anyone with an idea as to why I'm getting that?

I'm running Vista Home Premium on a Toshiba P200.

Answer:Forward slash button doing the following

MS Gothic font that's doing it - other font(s) is not. Any idea as to why particular font might be doing this? Am I in the wrong forum to ask a difficult question like this?

1 more replies
Relevance 77.08%

If I type in or copy a file location in W7 (using back slashes) then try to paste it into a box in another application I get forward slashes and the application, whatever it is, cannot find that location.

Eg.
I type Z:\Graphics\Animals\Birds II\Lunch
I get Z:/Graphics/Animals/Birds II/Lunch

I've tried it on several applications and never had this problem with XP (on different computers). This is annoying as all get out, and I wonder if Windows 7 keyboard codes are screwed up, or is it my hardware?

Answer:Forward - Backward Slash?

It would be your applications they do not understand the forward slash.
Windows it self has no problems with forward slashes.

1 more replies
Relevance 77.08%

Ok, I give up. I've heard it as both the forward and the back slash key.

So, for the last time, the slash that is underneath the question mark key, is that the forward or back slash?

Lymponus
 

Answer:Forward or Back Slash?

6 more replies
Relevance 77.08%

Fired up my x64 Vista Home Premium this morning and found something odd....Gray forward slash marks on document icons. Cannot interact with them, nor can i find any information about what they might be?!? Anyone?

Answer:Gray Forward Slash???

RMHG

Hi and welcome to vistaX

Just a friendly note cause you are new.. Double posts aren't allowed. No problem Just wanted to let you know

again welcome

Ken

7 more replies
Relevance 77.08%
Question: Date format

Know little about scripts - help requested.Using 'last modified' script to show when web page was last updated.It works OK except for US style date format MM/DD/YY, ie, 9/11/03 = 11th September 03.Is there a simple way to revert to UK format DD/MM/YY, ie, 9/11/03 = 9th November 03.

Answer:Date format

I'm assuming that you're using a JavaScript to display the information.Rather than me giving you a load of instructions on modifying the document.write properties within the script you are using, here are links to a couple of alternatives that display in UK date format:click hereclick here

2 more replies
Relevance 77.08%
Question: Date Format

Hi,

The default date format is MM/DD/YYYY. How can I save and display as DD/MM/YYYY? This is very important cos' after I entered in DD/MM/YYYY, Access still convert it as MM/DD/YYY.

Thk a million!
 

Answer:Date Format

Form Access Help
Microsoft Access can display a wide range of international formats. To help ensure consistency among applications, Microsoft Access uses the regional settings in Microsoft Windows Control Panel for the predefined Number and Date/Time formats. If your data isn't displayed in the right format for your country/region, change the regional settings specified in Control Panel.

But you can set them manually as well.
 

1 more replies
Relevance 77.08%
Question: Date format

Is there a way to change the date format the machine uses.
For example, my machine organizes pictures by date, but mm/dd/yyyy doesn't really facilitate finding anything.

yyyy/mm/dd would be much better.

TIA

Answer:Date format

This might be what you are looking for. Click here

1 more replies
Relevance 77.08%
Question: Date format in DOS

i am using windows 2000 platform. i want to create a dos batch files that would create a backup or archive files.

e.g.

Code:

d:\data\in
09/05/2006 05:46 PM 12,747,232 file01.txt
09/05/2006 05:46 PM 335,320 file02.txt
09/05/2006 05:46 PM 287,742 file03.txt

when the batch runs it will check for the current system date and will copy the files to another folder as

d:\archive\in

09/05/2006 05:46 PM 12,747,232 file01-09062006.txt
09/05/2006 05:46 PM 335,320 file02-09062006.txt
09/05/2006 05:46 PM 287,742 file03-09062006.txt

how do i achieve this? thanks.
 

Answer:Date format in DOS

It has been so long since I have worked in MS-DOS it is not funny but here is a page that might be of some help to you

http://www.chebucto.ns.ca/~ak621/DOS/Bat-Adv2.html

Have fun and enjoy
 

3 more replies
Relevance 77.08%
Question: Date Format

In Excel 2007 if I enter the date September 15, 2010 and format it to text I get 40436. What does the 40436 represent?

Answer:Date Format

The number of days since 1/1/1900, apparently. Change the formatting on the cell to one of the date formats.

3 more replies
Relevance 77.08%

In Excel 2007 I'm trying to format a cell to format for mm/yy. I want the input to be ONLY mm/yy. I have a custom form for mm/yy; but the input keeps translating it to mm/dd/yyyy. This may be OK except I'm dealing with Brits and they want dd/mm/yyyy and anyway I ONLY want mm/yy.Help.

Answer:I want a date format of mm/yy

You should first make sure that all your DATES are really dates, not TEXT.Highlight all of your DATE cells and format them as General.They should all show as numbers similar to: 40703 which is July 6, 2011.Excel keeps track of dates by counting the number of days since Jan 1, 1900Once you know that all your DATE cells are really dates, then do a Custom format of: MM/YYMIKEhttp://www.skeptic.com/

2 more replies
Relevance 77.08%

Hi I'm in the UK. I'm running windows 7 (32)
I have a particular program that will not even start up if the regional date setting is not set to USA format i.e. Month/Day/Year it just gives an error message saying time date error. With the date set as USA format this program works fine. The problem is, all my accounts are run using excel. Where invoices, receipts and bank statements are all sorted by date using the UK Format Day/Month/Year. Invoices I sent out on 3rd Nov 2017 (show up as 11/03/17) are now listed in March's invoices.
is there any way around this. for example using a batch file to change the date format before the program starts and the returning it to UK date format after program finishes, or any other way around this dilemma.
 

Answer:Date format changes

Hello

Hopefully some of our members will chime i soon.

@phillpower2 @georgeks
 

0 more replies
Relevance 77.08%
Relevance 77.08%
Question: Date format

I have just had my pc at work upgraded from XP to Vista, and now all my dates are in the wrong format. For example if I type in 19/11/14 on my database, it automatically changes to 14/11/2019. I've checked the global settings, and they are set to English, United Kingdom, Short date. Our IT guy has discovered the date is wrong when he checks it using the cmd prompt, but can't seem to get it to change. All previously created spreadsheets etc., have change so the dates are wrong. Any advice on how to change it in DOS?
 

Answer:Date format

Go to the Region settings found in Control Panel and check your Short date format make sure you set it to dd/mm/yyyy.
 

2 more replies
Relevance 77.08%
Question: date format in xp

The system default short date format is: dd-MM-yyyy. We have an application that runs with the date format in: mm/dd/yy. and changes automatically Is there any method (e.g. batch) so that we can launch the application and then change back to the system default after close the application without the need to ask user to do the change manually via the Control Panel? ThanksThanks, any help appreciated

Answer:date format in xp

Is there any method (e.g. batch) so that we can launch.. You better post this in the programming section.Happy is ONE who says I am an OttoMAN.

3 more replies
Relevance 76.67%

I am using the "microsoft access date/ time picker" control to pick dates. These dates like termination date of a contract will end up in the database. The problem I have is that when I do this,

rst!dateIntoForce = Me!ActiveXCtlDOForce

I end up with this in my database:

1/6/2003 5:48:43 PM

How can I extract only the date part from "1/6/2003 5:48:43 PM" so that only

1/6/2003

goes into the database
Thanks
 

Answer:Date Part only from MS Access Date picker control

Format the date before it gets entered into the db. Format([Date], "m/dd/yyyy")
 

1 more replies
Relevance 76.67%

I have a Date/Time field that I need converted to just a Time field.

It comes back with 2/11/12 0:00:00

I need just the 2/11/12

I thought about changing it to a text field but I think there will be an issue with the month because it does not bring back a 0 in from the months with only 1 digit.

This table that I am creating is being sent to a txt file and that is where I see the issue. It looks good in Access, but not the txt file.

Any suggestions?
 

Answer:Solved: Access - Convert Date Time to Date

10 more replies
Relevance 76.67%

Hi there

I know how to do add a criteria to a Query. For example in the QBE pane in design view in the criteria row I enter this statement: Between [Start Date] And [End Date]. When I open up the form that is bound to the query, a message box pops up and I enter the required dates and I get the required data that is between the dates that I specify. However, I'm now finding out that this method is now becoming a nuisance.

Is there a way that I can have 2 unbound controls - one for the start date and the other for the end date in a criteria form. This way I input the dates I want for a particular customer and the form with the required data shows up. For example, I have already developed a criteria form for customers. I have an unbound combo box control that has customer names and when I click on a particular customer name, all the data for that customer is displayed in a form. In the row source of the unbound combo box control there is a SELECT .... FROM ... statement. I also have a button next to the unbound combo box control that opens up the form for that particular customer. Now I want to add two more Unbound controls in the criteria form, one for Start Date and another for End Date.

This way I can select a customer from the customer combo Box, select the start start date from the start date combo box and the end date from the second combo box control and get the desired data for that particular customer between the specified dates. I have attempted to do this bu... Read more

Answer:Access - Start Date and End Date in a Criteria form

Mario: What you want is called a query by form (QBF). I don't know how to do them myself, offhand, but here's the MS Technet article:
http://support.microsoft.com/?kbid=235359
 

2 more replies
Relevance 76.67%

I accidentally formatted the date cell & it only accept numbers

Answer:how to correct a date field when you enter a date a number a

I don't know what you mean by "it only accepts numbers".Why can't you just format it as a date again?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 76.67%

ok i have a folder on my HD that contains over 60GB of data. within this folder there is many folders and files. is there a way of simply selecting this main 60GB folder and useing a prog to make all the file and folders have the same date/time that i wish?

i basicly want all the files and folders in this 60GB folder to be ...say todays date / time.

can this be done?
 

Answer:file date on a 60GB folder - setting them all to the same date? can it be done?

http://www.febooti.com/products/filetweak/

40 day fully working trial version.

Looks like it will do what you want.
 

1 more replies
Relevance 76.67%

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

3 more replies
Relevance 76.67%

Excel 2013 and Windows 10 Pro

Today is May-14

Date format is set to show: Mar-16
Pressing Ctrl+; shows: 05 14 2016 in the cell
and it converts to: May-16 after I exit that cell.

Any ideas as to how to fix this or why it adds 2 days to the date?

I don't do much on computer now because of health but when I do and there is a problem, I know some of the experts are here.

Thank you in advance, Ron
 

Answer:Excel Date shortcut posts proper date and then changes

Hey Ron,

This should be a fairly simple one. I'd hazard a guess and say the May-16 is the month and year rather than the month and day.
If you click the format drop down as shown below, and click the last option for more formatting options.

In the box that pops up, navigate to Custom using the left hand panel to navigate.
Here you can make your own (or use a preset if you wish) format to suit your needs.

Here is a quick key to help you get by:
dd = Day in Number format
ddd = Day in Short text
dddd = Day in Long text
mm = Month in Number format
mmm = Month in Short text
mmmm = Month in Long text
yy = year in 2 digits
yyyy = year in 4 digits

You can separate these with pretty much whatever you want.
All of this data is input into the "Type" field as shown in the picture above.

See the picture for an example, Ironically it is May 16th today so it will appear the same as your issue does, but rest assured, as long as you have those D's in there, it will display the day!

Best of luck,
Let us know how you get on,

Xsage
 

1 more replies
Relevance 76.67%

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

Answer:Excel date auto populate date/time

11 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End date question

16 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

3 more replies
Relevance 76.67%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

Wait for the more knowledgeable to report but a new CMOS Battery would seem to be in order.
Easy to replace and only £1, or so, to buy, in almost any Supermarket.
About the size of a 10p piece on the motherboard, with a number like CM032. Don't take it out until you are ready to replace it.
Get the replacement > Take the old one out > Instal the new one and, with luck, that should be it.

6 more replies
Relevance 76.67%

The AVG on my Dell thinks the Virus database is out of date even though it has the most current update?

How can I change the date back and what might have caused this to happen in the first place. I've heard of some AVG update problem but didn't find much relevant information on it.

Any suggestion or links would be great.

Thanks,
Andre
 

Answer:AVG Free wrong date set; Update thinks it's out-of-date

Check the date on your computer.. And, maybe uninstall AVG and reinstall it..

http://www.majorgeeks.com/AVG_Free_Edition_d886.html
 

2 more replies
Relevance 76.67%

Hello, I am having trouble finding the previous 2 days totals in a query. I have a totals query with the following fields:
JobID - Criteria: Between 500 And 599
WorkType
JulianDate
Batch
TotalProcessed - calculated field, grouped on Sum. sums field entry
ProdDate - Short Date - Grouped on Where - Criteria Date()-1 Or Date()-2

Today's Julian Date is 199 so query should give me Julian Dates 197 & 198, but instead returns Julian Dates 188 - 196.

Thank you for your help!
 

Answer:Solved: AC2007 Find Date()-1 And Date()-2 in Query

The criteria that you should use for a date period is
Between Date()-1 and Date()-2
 

2 more replies
Relevance 76.67%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

http://www.pcadvisor.co.uk/forums/1/tech-helproom/4204823/date-amp-time-reverts-to-date-of-pc-purchase-9-years-ago/
see duplicate thread

1 more replies
Relevance 76.67%

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

Answer:Stripping the date portion of date/time in excel

7 more replies
Relevance 76.67%

I received a .csv file from a company with a date field that looks like this: Tue Jan 03 12:12:20 PST 2012I have tried using the Data Type options to change this to a mm/dd/yyyy format but it will not apply. I tried converting it to a serial number using*mm/dd/yyyy and it will not work ~ nothing happens. I tried using a DATEVALUE formula but keep getting a #VALUE error .. I obviously don't know how to lay it out. Can anyone give me the DATEVALUE formula for this example? I am not sure what "right", "left" or "mid" represent or how to count the value placements. THANKS!!!

Answer:How do I convert a complex date to a simple date in Excel?!?

Try this:With your date in cell A1,First, format cell B1 as a DATE fieldRight click your mouse, select Format Cell, Select Number Tab,select Date, choose the date format you want.Next, in cell B1 enter the formula:=DATEVALUE(MID(A1,5,3)&" "&MID(A1,9,2)&", "&RIGHT(A1,4))That should give you what your looking for.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 76.67%

I want to calculate how long a member of staff has worked for the company and therefore need to subtract their starting date from the current date.

Answer:How to subtract a date from a date ie years/months elapsed

If you use google to search:Time elapsed calculatorThere are a few online results to help. I hope they help. For the fun of it I calculated how long I have been in existence : 2,177.43 total weeks or: 15,242.00 total days or: 365,808.00 total hours or: 21,948,480.00 total minutes or: 1,316,908,800.00 total secondsThat was from the first result google gave me. Thank god no one will be able to figure out when I was born. message edited by btk1w1

9 more replies
Relevance 76.67%

Hi All,
I am using LUMIA 1320 that has Lumia Cyan.
Sometimes the time and date is getting reset to a specific date, i.e. 22nd May 2014
Due to this all reminder, alarms and new messages are not coming in sync.
Is this a virus? Does it have come from an app. If that is the case then it questions Microsoft App policies...
Anyone who has encountered this issue and has done something to eradicate it let me know.

Answer:Why is my phones time and date getting reset to a specific date?

First, windows phone can never get a virus. Its the safest platform after iOS . And no, a particular app can't affect the system's time and date. I think your should try to manually set the time and date in the settings. And see if it works.

3 more replies
Relevance 76.67%

I've just moved "My Documents" contents from one laptop to another
I now find that some of the Word Documents are showing the current date in letters to customers that were created & dated months ago
As these letters are records documents sent out is there a way of preventing them opening with the current date

I've already checked, Wotd - Insert - Date & Time & the Automatic Updates box is unchecked

Thanks for any help

Answer:In Word the Original Date in a letter changes to current date

Is this the file modified date or the file created date? Moving the file will give it a new "modified" date.

1 more replies
Relevance 76.67%
Answer:ican not set date and time an error is occurewhile date and

Enter the BIOS & change the date/time. If it resets after the system has been shutdown for a while & then restarted, the CMOS battery is probably bad.

2 more replies
Relevance 76.67%

Hello. I have a cell on my spread sheet which calculates an earliest date due. The cell references other cells to achieve this and looks like this '=C51+(F8*7)' where cell C51 is a date field in the format DD/MM/CCYY and contains the date 26/12/2015. And cell F8 is a number field which contains the value '4'. This value '4' is indicating a number of weeks. So the calculation (F8*7) gets me the number of days and I then add those days to the date in cell C51 to get 23/01/2016.I want this cell to output the current date if the calculation above results in a date that is in the past. Can anyone tell me if there is a simple way to achieve this? Thank you.

Answer:Excel: Substitute a past date with the current date

If I understand you correctly, this should get you what you want:=IF("your calculation"< TODAY(),TODAY(),"your calculation")However, the TODAY() will update every day to always show the current date, assuming "your calculation" results in a date that is in the past.In other words, it will not lock in the first date it calculates. It will always display "today's" date.Is that what you want to see?One other issue: As explained at the link below, the TODAY() function is "volatile". That means that is will recalculate every time the sheet calculates, even if none of the arguments have changed. A large number of volatile functions can slow a worksheet down.https://msdn.microsoft.com/en-us/li...Volatile and Non-Volatile Functions

Excel supports the concept of a volatile function, that is,
one whose value cannot be assumed to be the same from one
moment to the next even if none of its arguments (if it
takes any) has changed. Excel reevaluates cells that contain
volatile functions, together with all dependents, every time
that it recalculates. For this reason, too much reliance on
volatile functions can make recalculation times slow. Use them
sparingly.

The following Excel functions are volatile:

NOW
TODAY
RAND
OFFSET
INDIRECT
INFO (depending on its arguments)
CELL (depending on its arguments)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 76.67%

The column heading in Win 10 File Explorer is 'Date'. But which one?

I've always been used in XP to the default being 'Date modified', but it seems that here it's Date created? Several re-saves have left 'Date' unchanged.

--
Terry, East Grinstead, UK

Answer:File Explorer Date column - whiich date is it?

Hi:
What is the column in Windows 7 explorer? It matches no date column from Windows XP explorer - Super User

2 more replies
Relevance 76.67%

I have a file that lists a Julian date of, for instance, 37573. How do I convert that into something like 11/06/02?

Thanks in advance!
 

Answer:Julian Date--How to convert to calendar date in Excel

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

That's how many days it's been since 1/1/1900.

To change it to a real date, you should be able to select that cell or entire column, hit Format-Cell, Number tab, and choose Date, and then any one of the date formats.

Julian dates are what numbered day of the year. For instance, January 3, 2002 would be 3.

Learn lots about dates and times in Excel:

http://www.cpearson.com/excel/datetime.htm

Be prepared to be there for a while.

Happy Thanksgiving!
 

2 more replies
Relevance 76.26%

this is embarrasingly simple I am sure........  my forward slash comes up as a pound sign and holding alt or any other function key makes no difference.  Incidentally most of my other alternate number keys dont match the face.  My pound is @ and so on.....

Answer:my forward slash gives me an alternate character

Try going to Regional and Language Options in Control Panel and changing your settings to English (US).It sounds like it's currently in the UK format.

3 more replies
Relevance 76.26%

When I use forward slash key in my computer it is giving hash sign. Can any one give a solution to this problem ?

Answer:Forward slash key giving hash

Change your Regional Settings in Control Panel --> Language and Regional Settings.

4 more replies
Relevance 76.26%

I live in the UK and want to use the day-month-year format in displaying the date.

In Control Panel, Region and Language, Additional Settings, I've changed my Location and Keyboard, and set my date format to 'd.MMM.yy' (short) and 'dd MMMM yyyy' (long). In the W7 betas, this gave me a day-month-year format in all programs.

In the RC, I get the format I want in the notification area, Windows Explorer and Directory Opus, but my other shareware programs (e.g. Macro Express and Clipmate) display American date format in their listings. I installed them in Compatibility Mode.*

Does anyone know a fix for this? - in the registry, maybe?

Mary

Answer:UK date format in Windows 7 RC

  
Quote: Originally Posted by MBernard


[...]

In the RC, I get the format I want in the notification area, Windows Explorer and Directory Opus, but my other shareware programs (e.g. Macro Express and Clipmate) display American date format in their listings. I installed them in Compatibility Mode.*

Does anyone know a fix for this? - in the registry, maybe?

Mary


Just to clarify, does this mean the date within these programs appears in the American format, or (say) in the Programs and Features 'Installed On' column?

If it's the former, I think the only way to make the changes is in the options for those shareware programs, rather than in Win 7.

5 more replies
Relevance 76.26%

I am merging some excel dates into a word document. As I want them to appear in UK format I have added the switch \@ "dd/MM/yyyy". Bizarely, although this works if the source date is one which can't be expressed in MM/dd/yyyy format (eg 24th September 2007 will show as 24/09/2007, as 09/24/2007 isn't a valid UK date format), other dates are not being formatted correctly, eg 9th October appears as 10/09/2007.Any thoughts? This is driving me mad!!

Answer:Mergefield date format

I seem to recall something very similar I experienced a few years ago. That said, I just did a simple test in Excel and Word and by default the dates were appearing correctly in DD/MM/YYYY format in the word document.Can I ask how the source dates are formatted in Excel? (i.e. what you see in the format, cells dialog with one of the date cells selected).On my machine it has defaulted to a custom format I have setup of dd/mm/yyyy.I think this behaviour can depend on the regional settings and date formats set on your PC, and also a date setting somewhere within office. Let me know re: excel format and we'll take it from there. I suspect in my case I ended up exporting the data to another format e.g. Access/Text File and merging that way to avoid the issue, but can't recall as it was some time ago.

6 more replies
Relevance 76.26%

Hi, this should be easy, how do I determine if the system date format is DD/MM/YYYY or MM/DD/YYYY.
 

Answer:VB get System Date Format

I had it figured out some time back but don't remember now. Although as far as I am remember, my method was not full proof and there was no way to tell a date format on days like 1st Jan, 2nd Feb, 3rd Mar, etc.

But still just give me a day or two and I will try to find it out.
 

3 more replies
Relevance 76.26%

I am having problems with dates. I am copying data from my office's server. the data contains months from 2010 to 2012. when i copy this file from the server to my system the year in the date changes to 2012 for all the dates. When the file is downloaded to any other system, the date remains the same. its a csv file. i need to edit the data based on dates only so its very important . pls help !

Answer:problem with date format

Without the csv file to test, it's hard for us to offer a specific solution. The first thing I would look for is differences between the system that works and the one that doesn't.Different versions of Excel? Different formats for the cells (Date vs. Text)? etc.Sorry, but again, not being able to replicate your environment, it's kind of hard for us to offer a specific solution.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 76.26%

I mentioned this in another post but now I've started a separate one.In WinXP, on the main Control Center window the version date is in the American format MM DD YYYY but in Vista it is correct, i.e. DD MM YYYY. I looked at a friend's Win98 version and that is also correct.Does anyone else have this or know why it is like this?

Answer:AVG 7.5 has date format wrong

Right click task bar and select adjust time, time zone.

6 more replies
Relevance 76.26%

I want to enter a column of date data in Excel 2008 for the mac for the the 4th wed of every month (payment fo SS check)

Answer:How do I enter the date format for the 4th mo

Enter this formula in Row 1 and drag it down.If you need to enter the formula in an different row, adjust the ROW() function portion so that it equals 1 in the first cell that you use it.=DATE(2011,ROW(),29)-WEEKDAY(DATE(2011,ROW(),4))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 76.26%

I like printing the date on the bottom of my email. But it always comes out like "07/02/03", I do not like this I would rather it look like this "Jul-02-03". At least the month with letters instead of digits. Does anyone know how to do this? And will it be the same in excel and word?

Thanx
 

Answer:windows date format

What mail program are you using?
 

2 more replies
Relevance 76.26%

Hya folks,

I need to enter a date in a table in access, however instead of using a normal input mask of DD/MM/YY I'd like to use the format DD.MM.YY as this is in line with the date format of all our bespoke software.

I've tried editing the input mask list to no avail. I'd like to keep the field as a date/time field as we need to do queries using it.

Any ideas gratefully recieved .

Thanks

Gogs
 

Answer:Date Format in Access

7 more replies
Relevance 76.26%

I'd already have a macro and an error is appearing for this macroSheets("VM Tracker").Range("E" & Rw).Value = NowSheets("VM Tracker").Range("E65536").End(xlUp).SelectSelection.NumberFormat = "mm/dd/yyyy"Basically I wanted All Column E be formatted as mm/dd/yyyy format.PLEASE HELP!Thanks.

Answer:macro help format date

re: "an error is appearing for this macro"Are you expecting us to guess at which of the hundreds of possible errors you are getting? Imagine how much more help we could be if you were just a tad bit more specific.Oh, what the heck, I'll play along.You are getting:
Run-time error '1004':
Application-defined or object-defined error
Do I get bonus points if I tell you why you are getting this error?OK, how about this?Rw = 0How'd I do?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 76.26%

Hi, I typed 7-12 and when i press enter, it keeps appearing Dec-7. I dont want the date. i just want 7-12. I have selected "general" formatting but it still jumps back to custom "date" format. Help!

Answer:Keeps getting Date format! Excel

Start your string with an apostrophe and Excel will accept it as text. The apostrophe will not appear in the cell.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 76.26%

I am working with thousands of lines of data and the date format is currently mm/dd/yyyy. I need the date to be formated as yyyymm.Is there a way to do this without typing them out again? Thank you.

Answer:Excel Date Format Help

What you want is Custom FormattingOn 2007 Home tab, Format, Format Cells, Customthen enter your format: yyyymmIn 2003 it'sFormat, Cells, CustomMIKEhttp://www.skeptic.com/

2 more replies
Relevance 76.26%
Question: Excel Date Format

I have run a Lottery Syndicate since the first draw (19/11/1994).Once a year I download the complete Lottery history as a .csv file. I then do a "text to columns" format and save it as an .xls file.Column A is "Drawn Date" but the date format is yyyy-mm-dd and I would like it to be dd-mm-yyyy.I highlight the column and go to Format, Cells, Custom, and select dd/mm/yyyy and OK it but nothing changes. The date in column A still shows as yyyy-mm-dd.How do I change this column please?

Answer:Excel Date Format

As the 'date' has been read from a CSV file I suspect that it is being treated as text. To convert a text value in B6 to a date you can use the following formula.=DATE(LEFT(B6,4),MID(B6,6,2),RIGHT(B6,2))

10 more replies
Relevance 76.26%

Hi We take raw data from the source system called (ariba). In the raw data we have difference date columns like (Accounting date,Paid Date,Invoice Recevied data) etc.The problem in the data is "few rows the date format would dd-mm-yy and few rows the date format mm-dd-yy.Unable to figure out this issue.Already i have tried with "text to columns" options converting this into correct date format still it is not working

Answer:Date format in Excel

i have tried with "text to columns" options converting this into correct date format still it is not workingIf the Text To Columns is not workingYou can use the =DATEVALUE() function to convert the TEXT to DATEBut this will only work on Dates that are formatted in your Operating System Default Format.In other words, if you use the American style MM/DD/YYYY as your System Date, then dates formatted in the European style of DD/MM/YYYY will not be changed correctlyand if you use the European Style the American style will not be converted correctly.So what is your System Date formatted as?I'm going to hazard a guess that you are using the European style date of DD/MM/YYYY and need to convert the American style.For this we can use the =DATE() function where we firstsplit the date apart and then put it back together in the correct order. With your American style Date in A1,put this formula in B1: =DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,4,2))This is for a Date with a 4 Digit Year.See how that works.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

2 more replies
Relevance 76.26%
Question: Date format Change

Hi All
Is there any way to give access to end users only to change Date format(from dd/mm/yyy to mm/dd/yyyy and vice versa). I don't want them to change the date just the date format.
Regards
Bharath

More replies