I need to create the following value:
// "ABC" + current date + some random number
ABC20160405123
I do as follows:
=CONCATENATE("ABC", NOW(), 123);
But instead of getting expected value I get something weird in date segment:
ABC42465.889227419123
How can I get pure date in concatenate()
?