Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 14th 05, 08:49 PM
Alden
 
Posts: n/a
Default How to convert Excel imported numbers from text to numbers?

We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers is
to edit the cell (press F2) and hit enter. I've tried every other method of
copying and pasting (even pasting special), but nothing seems to work. Any
ideas?

  #2   Report Post  
Old February 14th 05, 08:56 PM
Peo Sjoblom
 
Posts: n/a
Default

Copy an empty cell, select the import and paste special and select add

--

Regards,

Peo Sjoblom


"Alden" wrote in message
...
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers

is
to edit the cell (press F2) and hit enter. I've tried every other method

of
copying and pasting (even pasting special), but nothing seems to work.

Any
ideas?



  #3   Report Post  
Old February 14th 05, 09:11 PM
 
Posts: n/a
Default

Depending on the version of Excel, you should get a
caution sign next to the cell when you highlight a number
stored as text.
When you put your cursor over the caution sign, it gives
you the option to convert the number stored as text to a
number.

If highlight a range that has a number stored as text at
the upper left, the convert will work for the whole range,
but you might have to scroll back to the upper left of the
range to see the caution sign

-----Original Message-----
We have a software package from which we can export data

to MS Excel.
However, when exported it arrives in Excel as text. Even

though they are
numbers, they act like text. The only way to convert

them text to numbers is
to edit the cell (press F2) and hit enter. I've tried

every other method of
copying and pasting (even pasting special), but nothing

seems to work. Any
ideas?
.

  #4   Report Post  
Old February 15th 05, 05:05 AM
2rrs
 
Posts: n/a
Default


Alden wrote:
We have a software package from which we can export data to MS Excel.


However, when exported it arrives in Excel as text. Even though they

are
numbers, they act like text. The only way to convert them text to

numbers is
to edit the cell (press F2) and hit enter. I've tried every other

method of
copying and pasting (even pasting special), but nothing seems to

work. Any
ideas?


Have a look he
http://groups-beta.google.com/group/...6d88671983a8e3

  #5   Report Post  
Old February 15th 05, 03:11 PM
Alden
 
Posts: n/a
Default

Simple, elegant solution. Thanks for the help! You've saved me from carpal
tunnel syndrome.

Alden

"Peo Sjoblom" wrote:

Copy an empty cell, select the import and paste special and select add

--

Regards,

Peo Sjoblom


"Alden" wrote in message
...
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers

is
to edit the cell (press F2) and hit enter. I've tried every other method

of
copying and pasting (even pasting special), but nothing seems to work.

Any
ideas?






  #6   Report Post  
Old February 15th 05, 03:19 PM
Jeff H
 
Posts: n/a
Default

Alden wrote:
We have a software package from which we can export data to MS Excel.


However, when exported it arrives in Excel as text. Even though they

are
numbers, they act like text. The only way to convert them text to

numbers is
to edit the cell (press F2) and hit enter. I've tried every other

method of
copying and pasting (even pasting special), but nothing seems to

work. Any
ideas?


I use ASAP Utilities add in. One of its many features will change text
numbers to numbers in a range (or do the reverse). Go here...
http://www.asaputilities.com/

  #7   Report Post  
Old April 1st 05, 12:49 PM
 
Posts: n/a
Default

Hi Peo, (pls excuse me.. ) I dont understand your "import"?? ... the rest of
your solution is more or less the same as "Help" offers (add instead of
multiply etc.), but it doesn't work for me... and I won't use an add'in.. as
I don't know how that will work. I do mail you directly too..
Bregards Jonna

"Peo Sjoblom" wrote:

Copy an empty cell, select the import and paste special and select add

--

Regards,

Peo Sjoblom


"Alden" wrote in message
...
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers

is
to edit the cell (press F2) and hit enter. I've tried every other method

of
copying and pasting (even pasting special), but nothing seems to work.

Any
ideas?




  #8   Report Post  
Old April 1st 05, 05:39 PM
Gord Dibben
 
Posts: n/a
Default

jonna

Try this(same as Peo's but with more detail).

Assume your range of cells that contain the exported data is A1:A10

Format these cells as General.

Format an empty cell as General.

EditCopy that empty cell.

Select A1:A10.

EditPaste Special(in place)AddOKEsc.


Gord Dibben Excel MVP


On Fri, 1 Apr 2005 03:49:02 -0800, "
wrote:

Hi Peo, (pls excuse me.. ) I dont understand your "import"?? ... the rest of
your solution is more or less the same as "Help" offers (add instead of
multiply etc.), but it doesn't work for me... and I won't use an add'in.. as
I don't know how that will work. I do mail you directly too..
Bregards Jonna

"Peo Sjoblom" wrote:

Copy an empty cell, select the import and paste special and select add

--

Regards,

Peo Sjoblom


"Alden" wrote in message
...
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers

is
to edit the cell (press F2) and hit enter. I've tried every other method

of
copying and pasting (even pasting special), but nothing seems to work.

Any
ideas?





  #9   Report Post  
Old April 1st 05, 08:41 PM
 
Posts: n/a
Default

thanks, but the real problem was that the "numbers" had an empty space in
front. I did find out and have used functions "Left" and "Right" .. with
sucess...
br
Jonna

"Gord Dibben" wrote:

jonna

Try this(same as Peo's but with more detail).

Assume your range of cells that contain the exported data is A1:A10

Format these cells as General.

Format an empty cell as General.

EditCopy that empty cell.

Select A1:A10.

EditPaste Special(in place)AddOKEsc.


Gord Dibben Excel MVP


On Fri, 1 Apr 2005 03:49:02 -0800, "
wrote:

Hi Peo, (pls excuse me.. ) I dont understand your "import"?? ... the rest of
your solution is more or less the same as "Help" offers (add instead of
multiply etc.), but it doesn't work for me... and I won't use an add'in.. as
I don't know how that will work. I do mail you directly too..
Bregards Jonna

"Peo Sjoblom" wrote:

Copy an empty cell, select the import and paste special and select add

--

Regards,

Peo Sjoblom


"Alden" wrote in message
...
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers
is
to edit the cell (press F2) and hit enter. I've tried every other method
of
copying and pasting (even pasting special), but nothing seems to work.
Any
ideas?





  #10   Report Post  
Old April 1st 05, 09:51 PM
Gord Dibben
 
Posts: n/a
Default

Thanks for the feedback Jonna.

That was my next suggestion, but no need now.

But, I am surprised that a simple F2 and ENTER would work if there are spaces.


Gord

On Fri, 1 Apr 2005 11:41:06 -0800, "
wrote:

thanks, but the real problem was that the "numbers" had an empty space in
front. I did find out and have used functions "Left" and "Right" .. with
sucess...
br
Jonna

"Gord Dibben" wrote:

jonna

Try this(same as Peo's but with more detail).

Assume your range of cells that contain the exported data is A1:A10

Format these cells as General.

Format an empty cell as General.

EditCopy that empty cell.

Select A1:A10.

EditPaste Special(in place)AddOKEsc.


Gord Dibben Excel MVP


On Fri, 1 Apr 2005 03:49:02 -0800, "
wrote:

Hi Peo, (pls excuse me.. ) I dont understand your "import"?? ... the rest of
your solution is more or less the same as "Help" offers (add instead of
multiply etc.), but it doesn't work for me... and I won't use an add'in.. as
I don't know how that will work. I do mail you directly too..
Bregards Jonna

"Peo Sjoblom" wrote:

Copy an empty cell, select the import and paste special and select add

--

Regards,

Peo Sjoblom


"Alden" wrote in message
...
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers
is
to edit the cell (press F2) and hit enter. I've tried every other method
of
copying and pasting (even pasting special), but nothing seems to work.
Any
ideas?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
roundoff when converting text to numbers Jack Excel Worksheet Functions 3 January 30th 05 01:51 AM
convert a number in Excel from numeric to text, i.e. "1" to "one" buenavisionpaul Excel Worksheet Functions 1 January 27th 05 06:30 PM
excel - numbers as text Thuferhawat New Users to Excel 12 January 24th 05 09:29 PM
Excel Adding duplicated numbers together JJ Joobler Excel Discussion (Misc queries) 1 January 7th 05 01:24 AM
How to Replace numbers and text with numbers only? Robert Judge Excel Worksheet Functions 3 November 5th 04 04:36 PM


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017