Format as General then F2 and ENTER.

If you have a great lot of these, copy an empty cell and select the great lot of
cells and Paste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On 5 Apr 2007 03:41:10 -0700, "guy.yeon" wrote:

Hi Thanks for the advice.

I had tried that too but it didn't work.

Thanks,
Guy