Jan
16
2013

Using Concatenate function in excel without impacting custom format

Suppose you have date time text in one column (format as YYYY-MM-DD) which you want to use in your concatenate function without changing custom format, because if you don’t do it then in concatenate function it will come in some numerical form for e.g. 40513 instead of 2010-12-01. It happens because excel ignores formatting.   Use below to fix it, Say column name is A1 where date value resides and you want to sue it […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

January 2013
M T W T F S S
« Dec   Feb »
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: