Data not recognized as a number

D

David Bateman

How do I programmatically get numbers recognized as numbers in a excel
sheet? It contains some sort of data dump which is not recognized in excel
as a number. I select the column and then Format, Cells, Number. Then I
delete the last number in each cell and replace the same number. Then it is
recognized as a number and shifts to align to the right. Is there an easier
way?

Thank you in advance,

David
 
G

Gord Dibben

Maybe the data is coming in as text.
Simply formatting the data to number will not do the trick, as you have found.

Format all to General.

Copy an empty cell.

Select the range of data and Edit>Paste Special>Add>OK>Esc

If this doesn't work, perhaps you have some spaces or extra hidden characters
from the data dump.

Post back if that's the case.


Gord Dibben MS Excel MVP
 
R

Ronald Dodge

You can use the TextToColumn method under the Data Menu Bar, or you can use
the PasteSpecial method by copy a cell with a numeric value of 0, then paste
to all other cells as Value and Add Operation. Either trick does just fine.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
 

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

Getting Access data to work in Excel formulas 3
Number Format. Switch Comma to Dot 1
Optional argument as Variant not acting like number 4
Convert a range of numbers to strings 2
Decimal numbers not recognized as numbers 3
Find Specific Rows in Range and Create New Tab 18
changing date formatted as general number into date format 4
Reduce Numbers Down To A Specific Value 1

Top