text()

[lezawang]

Hello

I tried this function, text(10,"dd/mm") and the answer was 10/01 which is Jan 01? Does that mean excel default month to Jan in this case?

Thanks

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[lezawang]

Thank you so much.

If you want to see the year, ask the TEXT function to show it to you...

=TEXT(1,"dd/mm/yyyy")