adding a dash

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
="-"&A1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Need to change numbers with dashes to numbers with no dashes 3
Word Dashed line formatting 0
dashes around cells 3
Adding a dash to phone numbers 2
formatted to place dashes within numbers formatted as text 1
ASAP Dash portable 0
zeros show as dashes in spreadsheet, want to show 0. 2

Back
Top