adding a dash

A

A.S.

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.
 
T

tim m

="-"&A1

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