Why does the excel TEXT(value,format_text) function's format_text argument not take "short date" as a valid value?

1
votes

The VBA FORMAT(expression,[format]) function's format argument is able to handle "short date". Is there a workaround to use "short date" with the TEXT function? I don't want to use VBA.

I tried using the excel CELL("format",reference) function to get the system short date format to use with the TEXT function but it is useless as it returns mm/dd/yyyy even if I use m/d/yyyy in my windows regional settings.

So basically my question is this - Is there a workaround to use "short date" with the TEXT function?

1
exceldatetextformatcell

1 Answers

0
votes

Not sure I understand the problem...............if I put:

=TEXT(TODAY(),"m/dd/yyyy")

in a cell, it displays:

4/18/2014

This is on a Win 7 - Excel 2007 machine.