Merge Cells - adding apostrophe before numbers

  • Thread starter Thread starter shawn212
  • Start date Start date
S

shawn212

I have a column of numbers that need apostrophes added in front of -
tried creating a column of apostrophes and doing the =A1&B1 - but whe
I paste value all I'm left with are the numbers. Any other ideas
 
You must log in or register to reply here.

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

Adding an apostrophe to a column of numbers 6
Apostrophe in Numbers 5
Formatting to text - apostrophe does not show 3
Cell format 6
Apostrophe In Data Downloaded 6
What is small green triangle in upper left corner of cell? 6
Number Text Format 2
Paste cells copied from another sheet 2

Back
Top