Date functions in Spanish
Thanks, David, that's exactly what we needed! However, I feel a little
embarrassed to have overlooked such an obvious setting. We appreciate your
assistance.
With that said, perhaps you could answer another question. How do we get
the format to capitalze the month or weekday name? In other programs, for
example, using "MMMM" in the format versus "mmmm", would capitalize the
month. Furthermore, "Mmmm" would only capitalize the first letter of the
month (proper caps). Any way to do this in Excel?
Thanks,
Richard
************
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Format Cell/ Date/ then choose the appropriate option in Locale (location)
--
David Biddulph
Blue Max wrote:
Has anyone had experience with implementing language options in Excel
2007? If so, we would like to know how to configure a worksheet so
that the date functions and formats will return a date in Spanish
rather than English. We are able to properly apply spell checks by
setting the language in the language bar, but are not sure how to
designate that certain cells (or a full worksheet) return Spanish
text for date, or other, text formulas?
|