software

how it works in excel quot;=datefmt()quot;?

Where did you find that? It is not one of the built-in Excel functions (at
least not in the English version)

--
Kind regards,

Niek Otten

quot;Vafa Ashrafiquot; lt;Vafa gt; wrote in message
...
gt; how it works in excel quot;=datefmt()quot;?
Hi Niek

it was on a excel work sheet that i had already on my pc and this function
convert genral text to date format as =datefmt(a1), and it works also !!!

quot;Niek Ottenquot; wrote:

gt; Where did you find that? It is not one of the built-in Excel functions (at
gt; least not in the English version)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Vafa Ashrafiquot; lt;Vafa gt; wrote in message
gt; ...
gt; gt; how it works in excel quot;=datefmt()quot;?
gt;
gt;
gt;

Probably it is a User defined Function (UDF)
Press F5 and type datefmt in the Reference box. If it is a UDF it will take
you to the VB Editor and show the code (if it is not protected in some way)
If you're lucky, it has some documentation in the code or the code is
somewhat self-explanatory. Otherwise post it here, if it's not too big

--
Kind regards,

Niek Otten

quot;Vafa Ashrafiquot; gt; wrote in message
...
gt; Hi Niek
gt;
gt; it was on a excel work sheet that i had already on my pc and this function
gt; convert genral text to date format as =datefmt(a1), and it works also !!!
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Where did you find that? It is not one of the built-in Excel functions
gt;gt; (at
gt;gt; least not in the English version)
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Vafa Ashrafiquot; lt;Vafa gt; wrote in message
gt;gt; ...
gt;gt; gt; how it works in excel quot;=datefmt()quot;?
gt;gt;
gt;gt;
gt;gt;