Format Cell

[Gunjani]

I like to acheive this dayte format in a Cell 27-Mar but also in the
same cell ( add text) i.e "27 Mar (Chq)"

At the moment I can only acheive 27/03/2006 (Chq) though the format is
set to dd-mmm in format/custom
Thx

Gunjani

 

[Bob Phillips]

Try

dd-mmm "(Chq)"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Gunjani]

But what if I wanted to put any text not just "(Chq)"

Thx

Yunus