Having problems with TEXT formula. dd.mm.yyyy format returns erroneous results

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


Answer
Answer
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?
---
Best wishes, HansV
https://www.eileenslounge.com

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.

 
 

Question Info


Last updated November 14, 2022 Views 9,594 Applies to: