On 24 Mar, 11:57, Jarek Kujawa wrote:
one way:

ActiveCell.NumberFormat = "dd.mm.yyyy;@"

what do you mean by "calling a macro from a cell"?


Thanks for your reply.

I apologise for the rather quickly written post.

In a few cells in excel I will parse a string into a date format and
would also like to set the format of that cell to Date (dd.mm.yyyy)
using vba.

So for instance in cell B4 I would write =FormatCell(L4). L4 would
then contain a text which will contain a date (and possibly other
text). The purpose of FormatCell is to parse the text but if the
format of the cell (B4) is not of type date the displayed value is
wrong (using the format "standard" give the following output 39432,
but using the format "date" give me the correct output of
16.12.2007).

Will give your example a try.