putting ' in a column of cells

  • Thread starter Thread starter Peter McCaul
  • Start date Start date
P

Peter McCaul

I'm combining two cells with the = A1 & " " & B1 formula. The a1 column
has numbers in it and I can only get that formula to work if I put a ' in
front of the numbers. The column is about 300 cells long. Is there a quick
formatting way in which I can do this? Any help is appreciated. Thanks.
 
It should work fine without the single quote. If you want some special
format

=Text(A1,"00000") & " " & B1

Use the format you want.
 
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

Re. Conditional formating of adjacent cells but down a column 0
Display entire number in cell 3
Problem with a loop and column references 27
How to do this with macro? 2
A data validation question 1
Putting Formula in all cells give Circular Reference. Please help 7
VBA set thick borders around non empty cells in range 0
Time Calculations Help 4

Back
Top