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