Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45 A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : `=TEXT(A1;"dd.mm.yyyy")` B2 : `=TEXT(A2;"dd mm yyyy")`
In the first case I received a
#VALUE Error in the cell
In the second case I received :
dd 03 yyyy like only the month is working.
I am under Windows 7 and Office 2013 Professional.
Any guess what it could be?