format within a cell

[ndello]

Here is a simple formula:
="Monthly report for "&D2
How can I change the format of the number I see in this cell without changing it directly in D2.
Thanks
Neil

 

[Mark W.]

Use the TEXT worksheet function...

Ex. ="Monthly report for "&TEXT(D2,"mmm")

 

[Andrew Poulsom]

Use the TEXT function, eg:

="Monthly report for "&TEXT(D2,"mmm-yyyy")

 

[Mark W.]

There's an echo in here...

 

[ndello]

Worked great thank you!