TextBox

[Ronbo]

I need a TextBox to have a formula to bring in a date,
i.e. A1=38141, formated to Jun-04. How do I get A1 into
a TextBox as Jun-04?

Any help is very much appreciated.

 

[jeff]

Hi,

Use =TEXT(A12,"mmm-dd") in A1; and A1 as your linked cell?

jeff