Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Shirley Munro
 
Posts: n/a
Default Converting Numbers to Text properly


We have part numbers some of which are a mixture of text and numbers and
some that are numbers only. Excel sees those parts consisting of only
numbers as numbers rather than text. Even if I format the column to
text, the numbers simply move to the left hand side but still see
themselves as numbers. I know I can precede a numeric value with an
apostrophe to make Excel see the cell contents as text however this is
time consuming. Once I have formatted the column to text, I can then
double click on each cell containing only numbers and it will then see
itself as text but again this is time consuming. In other instances
and particularly when bring the data into Excel from another source,
Excel converts long part number to exponents which is no use at all as
I can end up with duplicate parts – part no 234567112244 with show up
as 2.34567E+11 and so does part no 234567112245 where the last digit is
the only difference. Any suggestions.


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=345882

  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If you format as text, it will be text. Left aligned is text
don't know what you mean by
"but still see themselves as numbers"

If you bring it in as text you can use datatext to columns and select
text as column data format in step 3


--

Regards,

Peo Sjoblom


"Shirley Munro" wrote in
message ...

We have part numbers some of which are a mixture of text and numbers and
some that are numbers only. Excel sees those parts consisting of only
numbers as numbers rather than text. Even if I format the column to
text, the numbers simply move to the left hand side but still see
themselves as numbers. I know I can precede a numeric value with an
apostrophe to make Excel see the cell contents as text however this is
time consuming. Once I have formatted the column to text, I can then
double click on each cell containing only numbers and it will then see
itself as text but again this is time consuming. In other instances
and particularly when bring the data into Excel from another source,
Excel converts long part number to exponents which is no use at all as
I can end up with duplicate parts - part no 234567112244 with show up
as 2.34567E+11 and so does part no 234567112245 where the last digit is
the only difference. Any suggestions.


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile:

http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=345882



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
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
roundoff when converting text to numbers Jack Excel Worksheet Functions 3 January 30th 05 02:51 AM
converting numbers to text and prefill text field with 0's Jan Buckley Excel Discussion (Misc queries) 2 January 20th 05 10:03 PM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 11:19 PM
Converting text to numbers Scott Excel Discussion (Misc queries) 3 November 26th 04 10:17 PM


All times are GMT +1. The time now is 07:02 PM.

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

About Us

"It's about Microsoft Excel"