Blog Tools

excel date to string formula

Of some of the important commands in excel that I use often, I always tend to forget the syntax for converting date cell into a string/text. So here it is, I'm logging it again so that I can easily find the syntax.


Syntax:

=TEXT(cell id,"format")

Here's the sample:

=TEXT(A1,"DD/MM/YYYY hh:mm:ss")

Output

uses vba format uses vba format