Over 1 million tech questions and answers.

excel date format

Q: excel date format

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

RELEVANCY SCORE 200
Preferred Solution: excel date format

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

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
RELEVANCY SCORE 75.2

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
RELEVANCY SCORE 70

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

A:Date Format in Excel

Read other 7 answers
RELEVANCY SCORE 70

I was searching for a way to enter dates such that they are interpreted in the US (not UK) date format, i.e. mm/dd/yy not dd/mm/yy. It was unresolved in this closed thread http://forums.techguy.org/business-applications/910502-us-uk-date-format-excel.html
Since I've solved it, I'd like to share the simple solutrion with interested parties:

1. Close all Office applications.
2. Open Control Panel>Clock, Language, and Region>Region and Language>Change the date,time, or number format.
3. Under Formats, use the drop down to select "English (United States)".
4. Then close and open Excel. From this point on entering 7/1/11 will give you 1 July 2011, and not 7 January 2011.

Don't forget change it back afterwards (unless of course you're moving to the US
 

A:US to UK Date Format in Excel

You can also format the cells to your needs

Use the custom format
dd/mm/jjjj;@
mm/dd/jjjj;@

The ;@ forces the date to that format, you enter the date as you normally do so if it's Brittish dd/mm/yyyy and it will change to mm/dd/yyyy if the format is set to mm/dd/jjjj;@

What has to be clear for the use tis that he she has to enter the date as he knows ir should be

If they are used to entering day month year they will have to do that even though the format says different.

because February 1 2011 entered as 1/2/2011 will become 2/1/2011 in mm/dd/jjjj;@ format.

I hope I have been able to explain it,
The advantage is that you don't need to rememebr that you changed you country settings
 

Read other 3 answers
RELEVANCY SCORE 70

Hi

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?
Thanks
 

A:US to UK Date Format in Excel

Read other 7 answers
RELEVANCY SCORE 69.2

I have an elaborate Excel file (a weight reduction program) that includes a cell that shows the first day of a month (dd-mm-yy). Based upon which month of the year is in that cell, I want to make an IF statement that uses the number of days in that month (28,30 or 31 days). If I copy that cell and format it as a DATE per the mm format, it just prints the first letter of that month. Therefore, if there was a "J" in that second cell, the IF statement would not know if it was Jan (31 days), June (30 days) or July (31 days).

Anyone have any ideas?

Thanks
[email protected]
 

A:(Solved) Excel Date format

Hiya

Moved you to Business Applications, as you may get more help here

eddie
 

Read other 3 answers
RELEVANCY SCORE 69.2

Hi everyone,
I have a spreadsheet acting up.. when I try to put 7/17 for month/date and the cell is formatted to date it gives me 1/0 i think... no matter what date format I put, it gives me something else.
Anyone what any idea what is happening.

thx
AMD2800
 

A:Excel date format is not workinig

Read other 7 answers
RELEVANCY SCORE 69.2

I can't find how to change the date in my spread sheet to the following format 00/00/1999. It did work and now it is displaying what I think is the Juilian date. It is showing the correct format in the "edit" box, but in the spreadsheet and when I print it, it is just a number. (36983)

Please help.
 

A:Excel: Incorrect Date Format

Read other 11 answers
RELEVANCY SCORE 69.2

I am trying to combine information from a couple cells to create a date header for a column in a worksheet.

I want the cell to read:

Date: Thursday October, 21 2003

I can get the first two parts but the date comes back as a number:

Date: Thursday 37917

Here is the formula:

= "Date: " &'[WKH Daily Roster.xls]Sheet1'!$C$1& '[WKH Daily Roster.xls]Sheet1'!$D$1

The last part is the date "$d1$1"

I know this is probably simple but I searched help in Excel and on Micros.. site with no luck.

Help!!!
 

A:Format date within Excel Formula

Something along these lines?

= "Date: " &[Book1]Sheet1!$A$1&" "&TEXT([Book1]Sheet1!$A$2,"mmmm, dd yyyy")

HTH,
Andy
 

Read other 3 answers
RELEVANCY SCORE 69.2

I am perplexed. I have an Excel spreadsheet that contains 3 columns with dates. However when I see the spreadsheet the values do not appear as dates but as decimals - for example 39302.4652777778 . However, when I click and look in the formula bar - the date appears formatted correctly - 8/8/2007 11:10:00 AM. I tried to format the columns, pasting values in a new columns and even re-entering a date itself and still get the decimal even though the formula cell indicate that it is indeed a date. Can anyone help me?

Thanks in advance
 

A:Excel date Format problem

Read other 8 answers
RELEVANCY SCORE 69.2

I have a spreadsheet of invoices exported from my accounting program. I created a column and copied the invoice date to it then formatted the column with Custom, mmmm-yy. I want to create a pivot table that says for Apr-14 the total for object Code 6630 $$$$. I want to see that in April, 2014 we spent X for Food from Shamrock, Muder, and Sysco. Then what we spent in May, etc. I might not even care about the Vendor but I do want it summarized by month no matter how I do it, and I am trying to isolate our food costs.

It is not combining all of the Apr-14 lines though, but listing them separately.

Thanks
Carla
 

A:Excel Date Format Won't Pivot Right

i would use the group function , and just use the date field - no need to change
 

Read other 1 answers
RELEVANCY SCORE 69.2

I have an existing Excel spreadsheet that contains the date format mm/dd/yyyy. I want to convert it to mm/dd/yy. Excel will not convert the current cells to the new format without re-entering the information. Can anyone help? Thanks in advance.
 

A:Excel 2003 Date format

Read other 12 answers
RELEVANCY SCORE 69.2

I have not found a solutions which worked, datevalue returned #value etc. The basic problem is if your system date is not according to the date format in your text date column. So if you have set it to ISO, starting with the year, datevalue will not work etc.
This procedure worked fianally:

If the date format is like '12/31/2011 (US Format)
1. Change date format in CtrlPanel Regional & Language Option to the corresponding format, in this case mm/dd/yyyy
2. Select column with dates
3. Format Cells General.
Dates will change to Datevalue 40908 (Nbr of days since 01/01/1900)
4. Format Custom i.e. ISO Format yyyy/mm/dd (which really should be used everywhere)
5. Voila 2011/12/31
6. Change date Format in CtrPanel back to your Format
 

Read other answers
RELEVANCY SCORE 69.2

I need to have a column of continuous dates like this
Thur 1/01 or if necessary Thursday 1/01. I can find other formats for date available but not this way. I need to keep the column small. I have a formula that will do this
=TEXT("1/01/04", "dddd/mm/dd") but it will not allow me to auto fill series with the day of the week changing. Can anyone Help. Thanks
 

A:excel 2002 date format

Try a custom format, via Format -- Cells -- Number. Category = Custom, Type = ddd mm-dd (type it in the box). Click OK.

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 69.2

I'm trying to create an order form that will have some auto fill fields such as date, consecutive order number etc...

The first snag is the the date cell. Ideally I would like it to auto fill this field with the days date upon opening the spreadsheet, I couldn't figure that out so under 'format cell' I designated it as 'date' and chose dd/mm/yy as the format.

The weird thing is that when I enter the numbers for the date in that cell it show up as a completely different date. Example, I click on that cell and type: 041206 for todays date and the cell displays 10/24/12 ?? What the heck is that?

Thanks in advance!

Steve

A:Excel Date Format Is Screwy?

I have had, what I think to be similar problems and when you set the format to something specific (like mm/dd/yy) that is how you have to enter it, including the "/".

If you do it without the slash then excel interprets it differently and changes it. I am not sure why it does this or what it is doing but I do remember that typing the date exactly how the format was set ... solved my problem.

Read other 7 answers
RELEVANCY SCORE 68.4

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.

Code:
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
RELEVANCY SCORE 68.4

Hi again all,

Need a little help and this time I think it is possible I just lack the computer know how to pull it off.

I have attached a summary spreadsheet so I can reference as I go but I will give a little back story first. I want to create a spreadsheet that I can view and at a glance see who is traveling on a particular date and when they are due back. The problem is that the personnel will travel several times a year and I don't want to just create a giant spreadsheet with loads of dates.

Cell A3 is just the persons name and serves as no consequence for what I am asking.

In cell B3 and C3 I want to be able to display when the person is NEXT traveling and when that person is NEXT due back. Now this is the tricky part, I want this to automatically change the value of the cells after the date has passed.

In E and F I have put example dates. So lets say the 10th of July passes I would like the Outbound to change to 20th of Aug, and so forth. The same would apply for the inbound.

My thoughts were I could just dump all the dates at the bottom of the spreadsheet off the page break and have the text white so it is not visable and the sheet will be neat and tidy. There will be several people to track and I dont like clutter.

If anyone is particularly clever, could I even host all the dates for cells B3 and C3 on sheet 2 of the spreadsheet??

Once again, any help would be greatly appreciated.

Thanks & Regards
High
 

A:Format a cell in excel depending on date

Read other 8 answers
RELEVANCY SCORE 68.4

Down Under we show our dates as dd/mm/yy. I have a user who types in 3/4/00 and the system automatically reverses the date to 4/3/00. I have checked the properties on the regional settings, and the date options in Excel are also correct. I have tried, in Tools/Options/Calculations to change the date format to 1904, but the system wont accept it.

Any ideas for resolution appreciated.

Ms. Kumara
 

A:(Solved) Excel date format wrong

In my 4 years in customer services for a well known computer company, I have never seen that before.

Microsoft Excel does not control the dates nor the settings, ie currency etc. Which version are you using?

Try using another Microsoft program like Word to see if you have the same problem, if not, then you would need to speak to Microsoft in New Zealand.

Also, double check to see under Regional Settings in Control Panel, in regional settings tab, make sure the setting is English (New Zealand), and press apply (if it is not greyed out. If it asks you to restart, press no and go to the Currency and Date tabs to make sure that the setings are for New Zealand.

If that fails, then you can *force* the machine to your own custom settings, by changing the values.

If all else fails, then it could be Windows itself.

Please email me to let me knowhow you got on.

James
 

Read other 2 answers
RELEVANCY SCORE 68.4

I have a user who is trying to update an Excel spreadsheet somebody sent them. In one cell, there is a reference to the date located in another cell. However, the way it is formatted, the date in the cell displays as just a number instead of the date ("September 22, 2010" displays in the 2nd cell as "40443".

In the second cell, there is some text along with the formula referencing the original cell containing the date. In the formula bar, it looks like this: ...Los Angeles, California 90013, on "&AP29&"

Yet in the spreadsheet, it displays like this: ...Los Angeles, California 90013, on 40443

In the original/refenced cell (AP29), the text entered into the cell is 9/22/2010, and is formatted to display as September 22, 2010.

Any idea how to correct the formula to display the date correctly?

Thanks a bunch.
 

A:Solved: Date format - Excel 2007

Hi Traci.

It's because the underlying value of the date is a number, which is how Excel interprets it no matter how it's formatted. To change it to display the date, you have to tell it it's a date within the formula. Try this:

...Los Angeles, California 90013, on "&TEXT(AP29,"m/dd/yy")&"

Without seeing the whole formula in the second cell I'm not quite sure about the positioning of the ampersands and quotes, but play around with it a little. Let me know if it doesn't work.
 

Read other 3 answers
RELEVANCY SCORE 68.4

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
RELEVANCY SCORE 68.4

I am trying to enter a date in a column as yymmdd but when I enter 09 as the year is drops the 0. I tried using different formats but that is not working either. For example, I changed the cell format to yymmdd and when I entered 090120 it displays 460926. Can someone tell me what I need to do to get it to display as I need?
Thanks!!
 

A:Solved: Excel 2002 Date Format

Read other 6 answers
RELEVANCY SCORE 68

Hi all

I created an Excel spread sheet that the user has to input among other things many dates. The spread sheet that I created has many users doing their share of inputting data. The problem is not the formatting of the dates, but how the date is entered into a cell. I have formulas that use the dates to calculate the days between dates and other date type functions. For example, if someone enters Jan. 15, 2006, the date is entered as a text and the formulas return a #Value. I have seen many types of date entries that return a #Value in many cells.

Is there a way that I can warn the user that he or she has entered the date in the wrong format in a MsgBox?? If someone out there has a macro that can accomplish one of the above, that would save me many headaches. The dates are in specific columns (J and K)and are not random throughout the spreadsheet.

Thanks again,

Mario
 

A:Correct Date format in Excel spread sheet

You can use Data > Validation to warn them (although if they copy/paste, that won't retain what you want).

Perhaps the best is to use a UserForm which can control input and formatting. That way they can not change it even after they enter the data.
 

Read other 2 answers
RELEVANCY SCORE 68

Does anyone know how to change the format of the [date] that is put into a footer?

Thanks!
 

A:Solved: Excel - Changing date format in footer

Hi slgraham22,

the only way is via a macro: http://support.microsoft.com/?kbid=213742

lol
Hew
 

Read other 3 answers
RELEVANCY SCORE 68

I have a list of events with dates that I want to enter in an excel worksheet and my problem is that the dates are not formatted the same:

-some are full dates and enter fine (day, month, year)
-some are month year only
-some are year only

Does anyone have any idea how I might get these all into one worksheet and be able to sort them?

I've read all the Microsoft stuff on how excel codes dates from Jan 1, 1900, so I'm dubious that there is a solution, but I would love to hear any ideas that might work or a suggestion for a workaround or other application idea for collectiing this data. It's a large project for a charity and they know less about excel than I do <g>.

thanks,

Tom O'Connell
 

A:Excel date format - multi formats allowed?

Read other 9 answers
RELEVANCY SCORE 68

Hi all,

I would like to conditionally format the attached spreadsheet so that each alternating week is shaded on whole set of rows.

Also with our roster the week runs Thurs to Wed.

I've looked quite a bit into conditional formatting now. But this one has me stumped.

Thanks for any advice.
 

A:Excel: Format rows based on date and a few other specifics

Read other 7 answers
RELEVANCY SCORE 68

i generate an xhtml , with date formats mm/dd/yyyy (eg. <date> 4/22/008</date>) and open it as an excel.
when i send the xhtml to japan,and the japanese open it as excel ,they see the date fields as dd/mm/yyyy .
however , I want everyone to see the report in my mm/dd/yyyy format.

what should i put int the <date> </date> tag in the xhtml so that it will it will open the same for evey location
 

A:problem with date format in excel, when it is open from different locations

Excel has it's own International setting for date formats so it displays as is chosen in the Excel "Setup". I don't know much about xhtml but you could try surrounding the date in text quotes to con Excel in to thinking it is text and therefore leave it's format alone.
 

Read other 2 answers
RELEVANCY SCORE 67.2

This site looks great...thought I saw question a while back when I googled here... After reading thru many programming questions here, I realize I know lots less than I thought! ha. Think its a simple Excel formatting, but its been a while.

I've downloaded UK bank files to Excel, and need to change all dates to US format (12/6/2012 to 6/12/2012), with their corresponding text & numbers columns, and then sort top to bottom (oldest to newest), rather than how they came in (newest to oldest) to complete 2 yr. accounting summary. Excel 2007 on Windows 7 laptop.

Thanks much, guys! Jillian

I've included a sample of the columns from Excel sheet. As you can see, there are 5 columns, (oops maybe it won't show as cols) so all corresponding info has to move with the date, when I sort earliest to latest, after changing format for the 2 yrs I have to do. The format options given did not work, even tho' it IS indate format, not text, but when importing, it was already imported as US, not UK. Need to change. Not sure how to set that up, and have all info follow on corresponding cols. Thanks.

27/06/2012 20-71-64 5346xxxx -3.7 PAYMENT EAST MIDLANDS TRAI REF 177 1969574810 BCC
26/06/2012 20-71-64 5346xxxx -28.16 PAYMENT W M MORRISON PLC REF 174 7731688810 BCC
26/06/2012 20-71-64 5346xxxx -13.99 PAYMENT SAINSBURY'S S/MKT REF 174 7884931810 BCC
26/06/2012 20-71-64 5346xxxx -10 PAYMENT LUL TICKET OFFICE. REF 177 7365217810 BCC
25/06/2012 20-71-64 5346xxxx -422... Read more

A:Solved: Excel date format from UK to US & accompanying text files

Read other 16 answers
RELEVANCY SCORE 67.2

Hi

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.

Thanks

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,
Number,
Choose your format.

lol
Hew
 

Read other 2 answers
RELEVANCY SCORE 67.2

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
RELEVANCY SCORE 66.4

I have a pivot table in Excel 2007 with grouped data based on the year and the quarter, so the date info looks like this:

Code:
Years Date
2009 Qtr1
Qtr2
Qtr3
Qtr4
2010 Qtr1
Qtr2
Qtr3
Qtr4
2011 Qtr1
(I know it's not really code but I didn't know how else to maintain the columns)
I have a chart based on this data but I need the dates (on the horizontal axis) to appear in a very specific format of Q109, Q209 and so on. Is there a way I can either alter what's in the pivot table to achieve this, could I use this data combined with the TEXT function somewhere else on my worksheet, or is there another workaround?

My source data is by month only and I'm using the pivot table to calculate the quarterly averages for me.
 

A:Solved: Excel 2007 pivot table date format for chart

Read other 8 answers
RELEVANCY SCORE 65.6

Hello everyone:

We are trying to build an update query in excel to update one date in b2 to the date that is a h2. However instead of returning a date it returns random numbers.

Any ideas?
 

A:Solved: Building Update SQL Query in Excel Return Wrong Date Format

Read other 6 answers
RELEVANCY SCORE 65.6

Hi, I've got something that keeps going wrong.\
I have a large file which I use at work to register and plan my colleague's tasks and resgiter (outside our regular vacation/sick/abscence, etc.) the different calls they are working on allocating this. But that works, that's not the issue.
I have a sheet named "Medewerkers", yes it's Dutch for Employees of Colleagues.

I extracted and stripped this portion. (June 16: removed this attachment, correct attachment in final post)

On this sheet double clicking in Column A on the name will open a userform to edit this one or if you double click the first empty row below it you get a blank form to enter the data.
Since I regularly ran into problems useing the ....ocx calendar picker I wrote my own date picker and it works. Using son supporting code I found the funtion GetDateInLocalFormat() does it's job.

But now the issue:

The person on the sheet has as starting date 01-03-2012 (in Dutch format this March 1, 2012) and ends August 2012

On my system and at work The date pickers selects it correctly, show is and the userfrom shows it as 01-03-2012 but when I press 'Vastleggen" (Commit) the date is saved as 03-01-2012 which in Dutch January 3, 2012 when I double click again the datpicker shows the default data as January 3, 2012.

The cell's format is dd-mm-yyyy;@ the system's settings are for code 31 which is Dutch and I have pasted screen shost of the settings that show this.

I... Read more

A:Solved: Excel (2010) Date format issue dd-mm-yyyy and I can't find the solution!

I changed my code a littel and instead of passing the date in local format I pass it as a serial date and then there is no doubt and the result is correct. But if somebody can offer a better solution, I'm all eyes and ears, and ... maybe it will help others who struggel with date values and the international settings
 

Read other 2 answers
RELEVANCY SCORE 59.2

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
RELEVANCY SCORE 59.2

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
RELEVANCY SCORE 58.8

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

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

Read other 9 answers
RELEVANCY SCORE 58.8

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

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
RELEVANCY SCORE 58.4

Hi,
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
RELEVANCY SCORE 56.4

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!
 

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

Read other 16 answers
RELEVANCY SCORE 56.4

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
RELEVANCY SCORE 55.6

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
 

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

Read other 3 answers
RELEVANCY SCORE 55.6

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?
 

A:Excel 2007 - Start Date and End date question

Read other 16 answers
RELEVANCY SCORE 55.6

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
 

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

Read other 1 answers
RELEVANCY SCORE 55.6

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.
 

A:Excel date auto populate date/time

Read other 11 answers
RELEVANCY SCORE 55.6

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!
 

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

Read other 7 answers
RELEVANCY SCORE 55.6

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!
 

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

Read other 2 answers