date in text string

H

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
 
F

Frank Kabel

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

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"

.
Click to expand...
 
Top