Over 1 million tech questions and answers.

Date format Change

Q: 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.

Read other answers
Preferred Solution: Date format Change

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.)


This may be helpful to some of you? I was irrated that WLM only displayed the day and month in its boxes. I have discovered that WLM takes its display settings from the 'Short Date' as setup in 'Control Panel', 'Regional & Language Options'. You can only use the preset options available in the drop down box but at least my boxes now include the year!
Hope I'm not repeating something that has already been covered in this forum only my search didn't reveal that?

A:Change Display Date Format WLM

All the date formats in the "R & L Options" drop-down boxes include the year, so I don't understand which WLM boxes were not showing the year or how it could be fixed by making another "R & L Options" choice that also included the year.

Read other 2 answers

I want change format Time& Date but when i change country to a format special for example English (united state) after click OK button at once return to previous format
help me!

A:Not Change Format Time & Date

Time Format - Change

Date Format - Change

Date and Time - Change

Format Regional Language - Change

Read other 1 answers

I have a column of dates in dd/mm/yyyy format, yet nothing I do lets me sort from oldest to newest.
Basically it doesn't recognize the column as having only dates, therefore only allows me to sore from A-Z.
I have tried what was posted on a few other forums, such as copy-pasting the column in notebook and
then back to excel. I've also tried the text to column wizard, with no help.
I've tried creating entirely new excel files and copy-pasting the dates there, either directly
or copying to notepad and then to the new spreadsheet. Nothing seems to work.

A:Can't change date format properly

they are not formatted as dates and probably text

can you attach here ?

click on the date cell and change the format to number or general
you should see a number like
which is today 16th Oct 2015

Read other 5 answers

Hi people, I'm new around these parts, but I'll try not to be an annoyance.

I had a client come in yesterday with a problem with MYOB displaying the wrong date format. Specifically, it displayed it in MM/DD/YYYY format, instead of DD/MM/YYYY.
Looking at MYOB support, it says it takes the Date format from the computers regional settings, and will change as you change the settings.

The machine is Windows XP SP2, it has no other errors that I've noticed. The machine is only a few months old.

We changed the regional settings, with no effect. We then went to customise the date format. If we made any chages, even selecting something from the dropdown boxes, it would say 'Invalid character' and not allow the changes. I hadnt added any characters, just selected one from the dropdown box. You'd think that they would be correct.

Any thoughts would be appreciated. I'm hoping to have the machine back in the office next week to work on it.

A:Unable to change Date Format


see if there is a bios update available for that motherboard

good luck

Read other 1 answers

I'm using ms office 2003 excel. I have a column date that is in a format of 20100410 and I would like to convert it to April 10, 2010. Any ideas?

A:Solved: change date format in excel

If the column is actually a date (not text) then highlight the column and go to Format, Cells. Select the Number tab and then click on the Date format. A list of formatting options will appear and you should find what you want.
If it doesn't work, do the same thing and select Number. If you actually have dates typed in, then 20100410 would show as 40278.00 - if it is text, it will show as 20100410.00.

Read other 3 answers

The Modified date of files in Windows Explorer is shown as Today - Yesterday - Friday ..... and if it's older than a week as a date 13/02/2013.

Is there any way to always show the modified column as date and not day-of-week?
thank you.

A:Change the format of Date Modified in Explorer

Hello Tera,

Go to Control Panel> Date and Time> click change date and time> click change calendar settings> click date tab:
(Make changes in red box to suit your desired taste - see below)


Read other 5 answers

Hi All

I'm trying to save a selected range of the excel spreadsheet as .csv file with a macro, all works fine but the dates are converted to a number eg 4/4/2004 becomes 38081.

the code i'm using is:

Const Folder As String = "C:\Clients\test"
Dim FileName As String
Dim LastCell As String
FileName = Folder
ActiveCell.PasteSpecial (xlValues)
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:=FileName, FileFormat:=xlCSV
ActiveWorkbook.Close Savechanges:=False
Application.DisplayAlerts = False

Anybody knows a workaround?


A:Solved: Macro change date format

Read other 6 answers

I would like to change date format to, e.g.,2014/01/12 or 20140112 at least for the command prompt screen.
It seems that this should be a simple item, but I cannot find out how to do it.
I would like to have it everywhere, but that might be too much.
The main reason is for sortability of copied lists, but it is also more readable.
We have used the 8 character format 20140112, and 20140112235959 for all of our data for decades.
Now we go to quadiseconds which is the limit of the double precision mantissa (irrelevant here).
The command prompt screen is relevant to me now.

A:I would like to change date format to, e.g.,2014/01/12 or 20140112

The option to change the format is to click on the date/time in the notification area (lower right), then click on change date/time. Then click on change calendar settings. You can change the format in the next panel that comes up.

Read other 2 answers

This is a continuation from this previous thread I started but is more specific to changing one more thing before I export the worksheet to a tab delimited file.

Need to add one more thing to this script and it has to do with the way the date is formatted in some of the cells. The cell gets exported as to what the cell format is versus what the true cell value is.

So for instance. The actual cell value that is typed into the cell is 12/23/2013 but the client put in a custom format of d-mmm so it displays as 23-Dec and that is how it gets exported to the tab delimited file. I need the cell to export to the tab delimited file as 12/23/2013.

So I tried this code to change the Date Formatting but this did not work.

If IsDate(rCell.Value) Then
rCell.Value = DateValue(rCell.Value)
End If
Anyone else got any ideas.

A:Excel Date Format Change with Vbscript

Read other 9 answers

Hi - I'm hoping someone can help. I have one computer with five users. My user is the admin and the other users are not. I have changed the date format under my user - but cannot do the same for the other users. I get the message to contact the system administrator. How do I get around this? I need all of the users to have the same, specific date format. Any help would be greatly appreciated. Thanks!

A:Change Date Format for multiple Users

Hi Brekai.

What you could do is add a group to the user just to allow them to change date and time

Date and Time - Allow or Prevent Users and Groups from Changing

Have a look at this tut

Read other 9 answers

My pivot graph X axis won't change it's date format. I've tried changing the raw data format, data format in the pivot table but when I try to change the graph data format it will not change. I looked the date choices and it seems like no matter what I do the pivot table will not change the date format! HELP!

The pivot date is suck in format
Saturday, July 07, 2007

I want it to be
07/07/2007 or anything but what is above!

A:Pivot Graph won't change Date Format

Click on a cell in your original data and see what it says in the formula bar at the top. Even though a cell reads, for instance, Sunday, July 01, 2007, if it is just formatting, it should read 7/1/2007 in the formula bar. If it does not (and I suspect yours will not), then the problem needs to be addressed there, in the original data. A pivot table graph takes the data that is there and displays that.
If that proves to be the case, do the following (this assumes your dates are in column A).
Highlight your column of dates, go to data, Text to columns, Delimited, put a check in commas.(BEWARE!! Text to columns will write over any other data, and this will write to 3 columns, so insert blank columns - extras don't usually hurt - after your dates and before any other data)!!!
The data will split out as Saturday|July 07| 2007 (where | indicates a new cell). Insert a new column between July 07 and 2007. Highlight the column with July 07 in it and go to data, Text to columns, delimited by spaces. Now you will have your data in 4 columns - day, month, day and year. Delete the column with the day (if you can) so the data is in columns A-C.
In the 4th column over (D, I am assuming), enter the following formula:
=CONCATENATE(A1," 0",B1,", ",C1) and drag it down next to your date columns.
(If you can't delete the days, it would be B1, C1, and D1, etc.) This will give you data that looks like July 01, 2007. In the next column over, enter this formula:
=DATE... Read more

Read other 1 answers

For the past week or so my date display has changed, and I think it has to do with XP rather than individual programs because it's changed in two programs, Microsoft Money and Outlook Express. I want my dates to be displayed as month/day/year, but instead they are now displayed as day/month/year. Call me simple, but it's confusing and I would like to change it back but can't figure it out. Thanks!

A:Solved: Change Date Format Setting

Read other 7 answers

Hi. Imported table has dd:mm:yy dates in two fields, illegible to Access. So I'm trying to change these to dd/mm/yy.
I'm getting syntax error (missing operator) in the strings. Any ideas?

Dim Dobdate As String
Dim Labdate As String
Dobdate = "UPDATE [New Non Trait Data] SET [Dob] = [0-9][0-9]/[0-9][0-9]/[0-9][0-9] WHERE [Dob] = [0-9][0-9]:[0-9][0-9]:[0-9][0-9] "
Labdate = "UPDATE [New Non Trait Data] SET [Lab date] = [0-9][0-9]/[0-9][0-9]/[0-9][0-9] WHERE [Lab date] = [0-9][0-9]:[0-9][0-9]:[0-9][0-9] "
DoCmd.RunSQL (Dobdate)
DoCmd.RunSQL (Labdate)

A:Solved: Access date format change

You do need VBA to do this, you can use either an Update query where you split up the incorrectly formatted date and put it back together with the correct "/" in place or you can just use a simple replace Query to replace the ":" with "/".

Read other 3 answers

It says it goes with the date and time format of you're os, my os has been changed to short date dd/MM/yyyy and the long date to dd MMMM yyyy. I done this through change date and time settings>calender settings. But the printer is still making a subfolder with date as so 2013_01_23 I want it to be 23_01_2013 is there something I am doing wrong? Thank you in advance

A:Does anyone Know how to change date Format on Canon MG 3150

Could you please be more specific? What for your All-in-one device is making a folder? Are you scanning something to a folder?
What software are you using? Solution is likely is in device's software.

Read other 4 answers


Using NotePad, I could enter the time and date using the <F5> function key. The format display is:


Is it possible to change it do the date came before the time



A:Using NotePad, change the behavior of the date time format

Hello Martin,

You might see if these tutorials may help.

Date Format - Change

Time Format - Change

Hope this helps,

Read other 5 answers

To change the system date and time format through registry. Below settings is working fine in Win 8.1 and other OS version but not in Win 7 version. I try to do it manually into the registry by changing the below values but still the format is not reflected
in the Date and Time.

Also I noticed that when I change the format manually in the Short Time in the "Region And Language" it doesn't change in the Date and Time shown in task bar , but its working fine when I change it for Long Time format manually. As i see in Windows
7 OS, it takes long time format to display in the task bar Clock and ignoring the Short Time format.

Is it because of any User level permissions required or anything settings to be enabled/disabled to change these values?.

RegistryKey rkey = Registry.CurrentUser.OpenSubKey(@"Control Panel\International", true);
rkey.SetValue("sShortDate", "dd/MM/yyyy");
rkey.SetValue("sShortTime", "HH:mm");
rkey.SetValue("sTimeFormat", "HH:mm");

PFB link for screenshots.


Read other answers


Can someone show me how to covert a date e.g. dd/mm/yyyy so that it reads as mm/yyyy only and so that a pivot table doesn't recognise the orignal long date of dd/mm/yyyy.

Tried using custom to mm/yyyy but pivot table still reads the date as dd/mm/yyyy.


NCFC (Newbie)

A:Excel 2007 - Change date format for pivot tables

hi NCFC,

Don't know about Excel 2007, but in 2003:

Right Click the Pivot Table,
Field Settings,
Select the field name that holds the dates,
Choose your format.


Read other 2 answers

in my data source the date field is custom ddd mmm dd yyyy

When I create the pivot table it shows as dd-mmm but when I try to format the field it already shows the format correctly but the sample show dd mmm

ie. Source table shows Thu Mar 26 2015
Pivot Table Shows 26-Mar

I am unable to reformat it to show the source.

So how do I get the pivot table to display the right date format?

A:Excel Pivot Table Date is in wrong Format and I can't get it to change

Have you definitely ensured all cells in that column are formatted the same in the source table?
I formatted the current date as you describe and created a pivot table with that data and Excel automatically used the same formatting. I'm using Excel 2013.

Read other 3 answers

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

Read other answers

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.  

Read other answers

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?


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


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.


Read other 9 answers

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?


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

Hi Steven,
Thanks for the post!
When you set the Short date to ddd dd/MM/yyyy, the date by the clock is shown with slash, however, the date in Task Scheduler doesn’t show the slash. This behavior
is by design. When you double click the time and the trigger tab (for example) in task scheduler, the details are shown with slash.
When you change the Short date to dd/MM/yy, the date in the Task Scheduler and the clock become the same.
For the Excel date problems, I recommend you ask this question in
Office Forum.
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and
other communities who read the forums regularly can either share their knowledge or learn from your interaction with us. 

Thanks for your understanding and cooperation!
Best Regards,
Miya Yao
 This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer
your question. This can be beneficial to other community members reading the thread.

Read other 5 answers

I want to format the date of Share Point list, I don't want to create Calculate formula column to format the date because. We cant change the existing date in Calculate formula date.
For Example
Existed date : 12/8/2018. here 
Calculate date : 12 Aug 2018
We cant edit the calculate date, but we can edit the Existed date.
While displaying the Calculate date it is disabling the Calculate date.
I want to change the date of Existed date and format into calculate  date.
"Here I have two question
1. Can we format the Existed date.
2. I know it is not possible to edit the Calculate date. But just asking any possibility is their to edit it."

Read other answers

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.

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

Read other 8 answers

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.

A: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.

Read other 1 answers

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.

A: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?

Read other 3 answers

I have a field in my spreadsheet that is Date()
I want to modify that to be date()+1, convert to pdf
Then change the date back to date() & save

I have already written VBA Code to do it all EXCEPT I don't know how to use VBA to change the date() to be date()+1 run my macro then change the code back to date()

Can a more avid VBA user help?

A:Solved: VBA to change Date - Save - Then Change Date Back - Save

Read other 10 answers

I have my files in firefox format..If i want to change the format for only my files without effecting some other files which are in same firefox format...what i need to do?

A:how to change files from firefox format to another format

The simple and obvious answer is to just change the files that you want changed and leave the others alone. But you must have something more in mind.

What is "firefox format"? To what format do you want to change? Using what tool, application or method?

Read other 1 answers

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.


A:Date format

This might be what you are looking for. Click here

Read other 1 answers

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



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


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.

A: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


Have fun and enjoy

Read other 3 answers

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?

A: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.

Read other 2 answers


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!

A: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.

Read other 1 answers

Tech Support Guy System Info Utility version
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

Read other answers

I am running WinXP-pro. When I print checks using Quicken 99 - the date always shows up in this format: "1/1/2006." (It never used to act that way when I was running the program on Win95). I don't see the "1/1/2006" in my long-date or short-date format in the control panel. And I don't see any formatting options for the date in the Quicken 99 program. Has anyone had this problem? thanks, thsh6

A:Date format in Quicken 99

Did you check Regional & Language Options in control panel? Beside your language (for instance English (United States) click on the Customize button, click on the last tab - Date - to change your date format.

Read other 1 answers

I just installed a split database on a non-profit organization's computer. In a table that contains date fields, I had set the date format to "m/d/yy" when defining the table fields on my computer. When I subsequently designed the input forms for the table, the dates show correctly in that format.

But when I installed the database on the client's computer, the dates show in "m/d/yyyy" format. I thought it might be because that computer's Regional Date Options were set to that format. However, I just experimented on my computer, changing the Regional Date format to "m/d/yyyy", then opening the database to see if the Regional format overrode the format defined in the table. It does not.

So. . . any idea why despite the date format being defined in the table as "m/d/yy" that on the client's computer, it displays as "m/d/yyyy"?

A:Date format not working

Read other 9 answers

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

A: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.

Read other 3 answers

When I create a footer in Excel 2000 the date format is always 12-03-2003. I can change the date format in cells with excel but not in the footer. I would like to be Dec-02-2003. I also change my setting under control panel/regional settings, this still doesn't seem to work. Does anyone know how to do this.

A:[Resolved] date format

Read other 14 answers

What format do I use when I type 010106 and want it to appear as 01/01/06?

A:Date Format in Excel

Read other 7 answers


There's a network, WinXP clients with a NT4 networkserver. When a user login (domain user) everything goes fine. But he or she want to change the date format to dd-MM-jjjj (Dutch) format. Keyboard settings, Dutch with US-International keyboard. That is not possible, an error message said "Not a valid date format". When I login as an administrator, there is no problem. Give (domain or local) user administrator rights, does'nt solve the problem.

Any ideas?

Read other answers

Can anyone tell me how to change the format of the date in a footer. I would like in to read "Jan-27-04"

A:excel date format

If you use the Custom Footer option, you can type in whatever you like. I could not find a way to enter the data so that it updates based on your computer's internal settings,

Read other 2 answers


I have a list of dates in Excel in US date format and I can't seem to get them to switch into UK date. I've tried the classic re-formatting and putting the data into notepad etc. Sure its pretty easy.

Any ideas?

A:US to UK Date Format in Excel

Read other 7 answers

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 .



A:Date Format in Access

Read other 7 answers

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?


A:windows date format

What mail program are you using?

Read other 2 answers

I want to format date in my batch script so that I may use it as file name.How can I format date from default formatting to dd/mm/yy ?

A:date format in script

These instructions should be what you want: http://findarticles.com/p/articles/mi_zdpcm/is_200406/ai_ziff128194

Will only work in XP.

Read other 2 answers