LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default Changing Text To Numbers ?

Hello,

Using Excel 2007.

Copied a list of "numbers" from a site.
They all "look like" numbers, e.g., 23.456.

Excel is apparently interpreting this as text, when I Paste what I
copied into it.

It appears on the left hand side of the cell.
I guess that this means that it thinks it is Text.
True ?

I tried re-formatting these copied cells as Numbers in Excel, but they
still appear on the left hand side of the cells.

What do I have to do to have Excel handle these as numbers, and not as
text ?

Thanks,
Bob
 
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
Changing A Column Of Text numbers To True Numbers: How ? Robert11[_3_] New Users to Excel 2 March 4th 09 09:08 PM
Changing text to numbers Schwimms Excel Discussion (Misc queries) 0 November 14th 07 04:51 PM
Changing numbers to text Des Excel Worksheet Functions 1 April 9th 07 08:58 AM
Changing Text to Numbers Hawksby Excel Discussion (Misc queries) 3 December 14th 06 06:23 PM
Changing Text into Numbers, using VBA Cecil[_3_] Excel Programming 5 April 13th 04 07:23 AM


All times are GMT +1. The time now is 11:55 AM.

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

About Us

"It's about Microsoft Excel"