The simplest way is:

=A1&""

in a helper column and copy down.

Then highlight the column with this formula, click <copy then Edit | Paste
Special | Values (check) | OK then <Esc, which will fix the values. Then
you can copy these and paste over the original values.

Hope this helps.

Pete


wrote in message
...

thanks Roger & Pete for the prompt reply.

It worked!! but as pointed out by Pete the single employee value
should be TEXT now how can i convert it to Text??

I tried TEXT function... but dont really understand wat shout I keep
'format text' parameter??

=TEXT(C1, ???)

or is there any other function to convert number to text?

Thanks again!!
Milind