I have a 18 sheet spreadsheet that has several columns of numbers. These
columns need to be converted to text with an apostrophe preceeding the
number (needed to upload the data to our web hoster). Can anyone give
me an idea as to how to accomplish this?


--
rslater44
------------------------------------------------------------------------
rslater44's Profile: http://www.excelforum.com/member.php...o&userid=32087
View this thread: http://www.excelforum.com/showthread...hreadid=518451

YOu can insert a column to the right of the number colum and enter the
following formula:

="'"&A1

Copy the formula down the column, select and copy the formula column, select
the first cell in the original number column and click EDIT in the menu,
select PASTE SPECIAL and click the VALUES check box to paste back only the
formula results. Delete the formula column.

If the column of numbers is in the same location on each sheet you can do
all the sheets at once by clicking on the first tab and the shift + click on
the last tab. You can than do the above function to all selected sheets at
one time.
--
Kevin Backmann


"rslater44" wrote:


I have a 18 sheet spreadsheet that has several columns of numbers. These
columns need to be converted to text with an apostrophe preceeding the
number (needed to upload the data to our web hoster). Can anyone give
me an idea as to how to accomplish this?


--
rslater44
------------------------------------------------------------------------
rslater44's Profile: http://www.excelforum.com/member.php...o&userid=32087
View this thread: http://www.excelforum.com/showthread...hreadid=518451