"Big Boss" wrote in message
...
I have data (numbers and text) in 20 cells A1 to A20 and I want to add "-"
in the front of contents of A1 to A20. How do I do it without using F2?

Select B1:B20, then type:

="-"&

Then click on A1, then press CTRL+Enter.

Refer to previous reply for how to convert these from formulas to actual
values.