date in text string

[Hans]

Im trying to make a text string that contains a date that
is mentioned in another sheet:

="results for the month of "&'Sheet(1)'!A1 &" and
following months"

However, the date in this formula is changed to a number,
although the date in sheet1 is formatted as mmm-yyyy.

Does anyone know how to solve this?

regards,
Hans

 

[Frank Kabel]

Hi Hans
try
="results for the month of "&TEXT('Sheet(1)'!A1,"mmm-
yyyy") &" and following months"

 

[Hans]

Hi Frank

It works. Thanks!

regards,
Hans

-----Original Message-----
Hi Hans
try
="results for the month of "&TEXT('Sheet(1)'!A1,"mmm-
yyyy") &" and following months"

.