changing "numbers formatted as labels" into numbers

  • Thread starter Thread starter kit
  • Start date Start date
K

kit

i have an excel spreadsheet that contains about 2000 rows of data. on
of the columns is a 17 digit number that acts like a label, (I canno
format the number. I think the data was converted from a database fil
into excel. when I received the spreadsheet, the numbers were formate
as labels. how can I get Excel to see this column as numbers and no
labels?

thank you for your help
 
You can't if they are 17 digits, or rather excel will truncate everything
after 15 digits.
You would need to use text representation of numbers like that

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Download the Excel Add-In from http://www.asap-utilities.com/.

It has a routine that changes text (labels) to real numbers that you can work with. This add-in has lots of other useful things as well. Solved the same problem for me.

Tom
 
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

format Column with horizontal alphabet label 3
How to change column labels back to letters? 1
Format appears stuck..how to break formatting 2
Conditional SUBTOTAL in XL210 Table 7
Column format when merging Excel data to Word labels 1
Numbers showing Up Centered in Cell ? 1
Columns formatted As Dates Are Exported as a Number to Text 1
Combining Rows on a label 1

Back
Top