Hello,
Excel 2003, cell A1 (format date dd.mm.yyyy) contains:
10.09.2013
In cell A2 I use the formula wizard to create the following:
=TEXT(A1;"dd.mm.yyyy")
Result: #VALUE!
Even more strange is that, sometimes (I don't know how) I get dd.09.yyyy !! I.e. it recognizes the month but not the whole thing.
Any idea what is going on and how to get around this problem?
Thank you
What is your system language? If it is different from English, you have to use the local format. For instance, on a French system, you'd use "jj/mm/aaaa" (j = jour, m = mois, a = année).
And are you sure that the value in A1 is really a date value? Is the value right-aligned if you don't specify the horizontal alignment explicitly?
---And are you sure that the value in A1 is really a date value? Is the value right-aligned if you don't specify the horizontal alignment explicitly?
Best wishes, HansV
https://www.eileenslounge.com
Report abuse
Details (required):
Thank you.
Reported content has been submitted
4 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.