Converting number to text

  • Thread starter Thread starter rslater44
  • Start date Start date
R

rslater44

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?
 
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.
 

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

Numbers stored as text 4
Number Text Format 2
Apostrophe in Numbers 5
Splitting text 11
How Can I Convert MBOX to HTML File? 2
Macro to add numbers in a text string 5
Calculate number of rows and apply formula 4
Adding an apostrophe to a column of numbers 6

Back
Top