Hi all,

Im looking for a formula/function which types the current Date and Time in a special format.

Format Example:

2012-06-20T15:04:13Z (YYYY-MM-DD T HH:MM:SS Z)

I was thinking a combination of the function "TODAY()" and som other stuff, but i cant make it work since the TODAY() function demands that the cell type must be "Date" and not "General".

Hope you can help.

Thanks