Heidi it this time let me talk about the text formula.
One of the very important formulas for presentation of DNA into a certain desired custom format in this
case I have a couple of dates for June 2011 which I want to present in this form either Friday or Friday
or 03 3 to to what indicates that turned off total of two.
So the formula goes like this text first thing it asks for is the value.
I choose the date value.
Next it asks for what is the desired format of output.
So in double quotation I give BD.
BD four times the I close the double quotation.
I close the bracket thereafter as soon as I press Enter what I get is Friday.
Now how do I put in just tripled the I would have got the short form of the day and how they put just
two dimes the letter D I would have got the actual deep seated.
Similarly I can also play that formula if I wish to find out the month name I choose the date comma
double gradation double double double double and close close the brackets and enter.
So if you wish to find just the shorter form of the montanum you would have used just three times the
letter M.
Similarly if you want to find out the calendar month sequence of the month of June then just two m will
be sufficient enough and goes without saying that if you had written text formula and chosen the date
and then double wide double Y in the double condition you would have got the year 2011.
Now what specifically is this format now this format text is the one which you generally get to see
inside for myself.
When I go to custom.
So any of these format which is generally found in a custom format can be enclosed in the pair of double
quotation.
So for example if there is a format which I prefer to have it on my screen that aspect to date I can
use a combination of the D M M M and Y Y Y in that sequence for example equal text choosing the date
comma than double condition.
I'm writing Deedy dot dot.
Y y y y.
I close the double tradition I close the bracket and I press enter.
There you go.
I have the date in 0 3 0 6 2011.
And this is also useful when you are combining the data with the prefix word bit and then you're combining
with actually did you notice it gets converted to a number.
Now this will happen why because every valeted is a number so make sure that you apply the text formula
before you choose the number.
In this case using the hyphen M and M hyphen y y and close using the brackets.
And so this way you have been able to concatenate or combine the word beat with the date that you wish
to point to in the desired format.
So that was text formal.