Hi there,
I've inserted the current date into an excel form using the TODAY() function.
I also need to provide the form in French, and when I change the language for the cell with the TODAY() function, it automatically abbreviates the month. For example, today's date appears as "13 nov. 2008" rather than "13 novembre 2008" as I would like it to appear.
Any ideas on how to change this?
Thanks!
Last edited by VBA Noob; 11-14-2008 at 09:37 AM.
custom format dd mmmm yyyy
That changed the appearance, but also changed it back into English. I don't want the whole spreadsheet to be in French, just the date. Any ideas?
jj mmmm aaaa i suppose but i dont know how you'd do that!!! my version of excel hasnt got the option but>2003 has a location drop down
Last edited by martindwilson; 11-13-2008 at 05:39 PM.
Try this custom format
[$-40C]dd mmmm yyyy
Hi daddylonglegs,
Is there a source / list where these custom codes (the [$-40C] part) are available? It would be useful to know of such a source!
Thank you DLL! That worked perfectly.Originally Posted by daddylonglegs
Hi,
It's not that far away
Put your date in A1, format cell and in "Locale (location)" drop-down select French (Canada), select the bottom one on the list, then Custom format and add an extra "m"
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks Oldchippy- I've learned another trick for my next accounting party
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks