="-"&A1

See if this does the trick for you (A1 would be your 1st cell of data, then
copy down the formula)

"A.S." wrote:

hi i need to add a dash to a cell...how do I do this? the number of
characters may vary so just need to add it in the beginning.