|
USA DTAE settings !
Hi,
I want to display the UK date in cell A1 of my worksheet, I simply type this formula into the cell... =TODAY() but no matter what I do , be it change the settings / display of that cell , I can't get it to be displayed as a UK date it always reverts to US !!!! Any help?? |
I'm not quite sure how a UK date is formatted, can you give an example?
Basically you can format a date whichever way you'd like by going Format-Cells-'Number' Tab-Custom, and inputting the format using 'y' for year, 'm' for month and 'd' for day. So if you wanted a date formatted 2005, Jan 12 you would type: yyyy, mmm d Does that help? -- Regards, Dave "Anthony" wrote: Hi, I want to display the UK date in cell A1 of my worksheet, I simply type this formula into the cell... =TODAY() but no matter what I do , be it change the settings / display of that cell , I can't get it to be displayed as a UK date it always reverts to US !!!! Any help?? |
Right click on the cell.... Select 'Format Cells'...... Select "Number" ....
"Date"... On the dropdown task bar "locale", select "English (United Kingdom)" "Anthony" wrote: Hi, I want to display the UK date in cell A1 of my worksheet, I simply type this formula into the cell... =TODAY() but no matter what I do , be it change the settings / display of that cell , I can't get it to be displayed as a UK date it always reverts to US !!!! Any help?? |
Didn't work guys,
Problem I have is 'somewhere' withing the VBA I have in my workbook, it is making all my dates default to the US version. As I said If I simply type =TODAY() in any cell the reply shown is 07/10/05, which is the US version, even if I then try and format this into the UK version as shown bu you it still defaults to the US..... aaaaaarrrrgggghhhh !!!! "David Billigmeier" wrote: I'm not quite sure how a UK date is formatted, can you give an example? Basically you can format a date whichever way you'd like by going Format-Cells-'Number' Tab-Custom, and inputting the format using 'y' for year, 'm' for month and 'd' for day. So if you wanted a date formatted 2005, Jan 12 you would type: yyyy, mmm d Does that help? -- Regards, Dave "Anthony" wrote: Hi, I want to display the UK date in cell A1 of my worksheet, I simply type this formula into the cell... =TODAY() but no matter what I do , be it change the settings / display of that cell , I can't get it to be displayed as a UK date it always reverts to US !!!! Any help?? |
Hi Anthony
07/10/05 is the UK version of date not the US. The US would be 10/07/05. If you are wanting to show 07 October 2005, then FormatCellsNumberCustom and select dd mmm yyyy Alternatively, in a cell type =TEXT(TODAY(),"dd mmmm yyyy") Regards Roger Govier Anthony wrote: Didn't work guys, Problem I have is 'somewhere' withing the VBA I have in my workbook, it is making all my dates default to the US version. As I said If I simply type =TODAY() in any cell the reply shown is 07/10/05, which is the US version, even if I then try and format this into the UK version as shown bu you it still defaults to the US..... aaaaaarrrrgggghhhh !!!! "David Billigmeier" wrote: I'm not quite sure how a UK date is formatted, can you give an example? Basically you can format a date whichever way you'd like by going Format-Cells-'Number' Tab-Custom, and inputting the format using 'y' for year, 'm' for month and 'd' for day. So if you wanted a date formatted 2005, Jan 12 you would type: yyyy, mmm d Does that help? -- Regards, Dave "Anthony" wrote: Hi, I want to display the UK date in cell A1 of my worksheet, I simply type this formula into the cell... =TODAY() but no matter what I do , be it change the settings / display of that cell , I can't get it to be displayed as a UK date it always reverts to US !!!! Any help?? |
Roger,
thanks I'll give that a go many thanks "Roger Govier" wrote: Hi Anthony 07/10/05 is the UK version of date not the US. The US would be 10/07/05. If you are wanting to show 07 October 2005, then FormatCellsNumberCustom and select dd mmm yyyy Alternatively, in a cell type =TEXT(TODAY(),"dd mmmm yyyy") Regards Roger Govier Anthony wrote: Didn't work guys, Problem I have is 'somewhere' withing the VBA I have in my workbook, it is making all my dates default to the US version. As I said If I simply type =TODAY() in any cell the reply shown is 07/10/05, which is the US version, even if I then try and format this into the UK version as shown bu you it still defaults to the US..... aaaaaarrrrgggghhhh !!!! "David Billigmeier" wrote: I'm not quite sure how a UK date is formatted, can you give an example? Basically you can format a date whichever way you'd like by going Format-Cells-'Number' Tab-Custom, and inputting the format using 'y' for year, 'm' for month and 'd' for day. So if you wanted a date formatted 2005, Jan 12 you would type: yyyy, mmm d Does that help? -- Regards, Dave "Anthony" wrote: Hi, I want to display the UK date in cell A1 of my worksheet, I simply type this formula into the cell... =TODAY() but no matter what I do , be it change the settings / display of that cell , I can't get it to be displayed as a UK date it always reverts to US !!!! Any help?? |
| All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com