The two functions are not the same... they have some functional overlaps
between them (the usage you asked about being one of them), but there are
many differences between them as well. The two functions exist in different
worlds and, as such, have functionalities built in which cater to the worlds
they exist in.

Rick


"Lars Uffmann" wrote in message
...
Peter,

Peter T wrote:
The "TEXT" worksheet function is pretty much the equivalent of VB's
Format function

Thank you very much, that is exactly what I wanted to know :) Though I do
kind of wonder why I have to know 2 different function names for doing the
same thing in VBA or cell formulas...

The only issue here is - while assigning "YYYY:MM:DD hh:mm:ss" to the
NumberFormat works perfecly, the format string passed to the text function
in the cells formula does not convert the format string to the computer's
region settings, and thus if you have german regional settings (and the
irony is - I made a point of setting my system up with an english XP!) -
it will only work if you use "JJJJ-MM-DD" etc. for the format string. Go
figure...

Thanks a lot, case closed I guess :)

Best Regards,

Lars