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