Hello,

How do i format a line to be separated by a new line character? I am using a formula that outputs a string and I would like to know how to separate that string into two lines.

Good Day ->  Good  
                      Day

Thanks,
That was a great suggestion. It work like a charm. There is one thing i would like to improve on my formula. My formula displays the abbreviation of the month value inside a date. It means if the date value is "2007-10-03", the formula will return "Oct".

My formula is as such
Year(DateValue("2007-10-03")) + Chr(10) + MonthName(Month(DateValue("2007-10-03")))

What i would like to return is
                                                        2007
                                                        Oct

So, should be year follow by a new line and the month abbreviation.
Instead, what it return was
                                                       2,007.00
                                                       Oct

I can to use string functions to modify the year, like extracting only the first five character of the year. But is there a easy way of doing this?

I just had another thought.