Add character to colum of numbers in Excel 2007

I have a column of numbers in Excel 2007.
I need to add " before and after every number. Eg change 123456 to "123456"

There are several hundred numbers to add this too.
MayogroupAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

try

=""""&A1&""""

copy down. Then copy the result and Paste Special > Values over the original data.

cheers, teylyn
0
All Courses

From novice to tech pro — start learning today.