Convert numbers from text format to number format

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

Guest

I have retrieved some data from external source and it put to my
worksheet in one column numbers in text format and if I want to work
with numbers (add, substract, etc.) I need it to convert to number format.
I tried to select column and mark it as number format however it doesn´t
work. Pls help me what to do, how to suceed. I have no chance to change
the format in source.

Juraj
 
Hi Merlin68,
I have retrieved some data from external source and it put to my
worksheet in one column numbers in text format and if I want to work
with numbers (add, substract, etc.) I need it to convert to number format.
Click to expand...

After changing the format, you need to convince Excel you meant what you
said <grin>:

- select an out-of-the-way empty cell, hit copy.
- select all your cells with numbers-to-be
- hit edit, paste-special and select the "Add" operation.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
thanks Jan Karel however I tried and failed. Perhaps I make some mistakes but
pls can you go step by step once more ? Really I do not understand why it
doesn´t work for me and believe what you typed is trues. Thanks once more

„Jan Karel Pieterse" napísal (napísala):
 
Hi Merlin68,
thanks Jan Karel however I tried and failed. Perhaps I make some mistakes but
pls can you go step by step once more ? Really I do not understand why it
doesn´t work for me and believe what you typed is trues. Thanks once more
Click to expand...

Are you sure the numbers do not contain any leading and/or trailing characters?

Another thing to try is to select the "numbers", then hit Data, Text-to-columns
and click finish.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
it is ok just now and pls take my apologize, i haven´t noticed i had dot
instead of comma for decimal separation, it was the reason of failing ..
so it´s ok .. have a nice day .. bye from slovakia

„Jan Karel Pieterse" napísal (napísala):
 
Excel must be forced to see the data as Numeric.

One way is to format all to Number or General then copy an empty cell.

Select the data copy then, in place, Paste Special>Add>OK>Esc.

Or select the data and Data>Text to Columns>Next>Next>Column Data
Format>General>Finish.

Now format to Number


Gord Dibben MS Excel MVP
 
Every week, our payroll clerks have been going through the sheets by hand and
hitting "F2" <Enter> through at least 200 rows of data. This should save us
quite a bit of time! Thank you!
 
Back
Top