Numbers act like text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We get spreadsheets from another application that have a column of "numbers"
that act like text. The only way to get them to act like numbers is to copy
them out to a text file and then copy them back in. Is there an easier way?
 
Format the cells with a numeric format, goto a blank non-text cell and copy
it, then select the range of 'text numbers', select paste special from the
Edit menu and choose 'Add" That will convert the text to numeric values, and
wont affect any cells containing true text in the selected range.

HTH,

TK
 
You could try this short-cut method - highlight the column with the
offending "numbers". Click Data | Text-to-columns and in the panel that
pops up just click Finish.

Hope this helps.

Pete
 

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 that are really not numbers? 10
Cell Error, Hidden Formatting 1
Counting average number of days between 2 dates 3
How to convert Excel imported numbers from text to numbers? 9
Numbers to Text 3
Numbers acting like text 3
Want to link a cell of numbers with a cell of text & can sort 1
Format appears stuck..how to break formatting 2

Back
Top