If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change number format from text to number?
Using Excel 2002, WinXP
I was given a spreadsheet with a very long column of numbers. Each cell displays the little green mark in the upper left corner. The dropdown arrow shows "number stored as text." When I then choose "convert to number" the number converts from text to number, which is what I want. But I don't have time to manually change each of the 6,000+ cells. If I highlight several cells, and do Format/Cells/Number/Number, the green mark in the upper left corner remains and the numbers in the cells are NOT converted to numbers but remain as text. Is there a way to globally change all numbers from text to number without having to manually do it one cell at a time? Thanks, |
#2
|
|||
|
|||
Change number format from text to number?
Scot
Format a blank cell as General. Copy that cell using EditCopy. Select your column of numbers and EditPaste SpecialAddOKEsc. Gord Dibben Excel MVP On Thu, 01 Dec 2005 01:49:54 GMT, "Scot" wrote: Using Excel 2002, WinXP I was given a spreadsheet with a very long column of numbers. Each cell displays the little green mark in the upper left corner. The dropdown arrow shows "number stored as text." When I then choose "convert to number" the number converts from text to number, which is what I want. But I don't have time to manually change each of the 6,000+ cells. If I highlight several cells, and do Format/Cells/Number/Number, the green mark in the upper left corner remains and the numbers in the cells are NOT converted to numbers but remain as text. Is there a way to globally change all numbers from text to number without having to manually do it one cell at a time? Thanks, |
#3
|
|||
|
|||
Change number format from text to number?
Scot wrote:
Using Excel 2002, WinXP I was given a spreadsheet with a very long column of numbers. Each cell displays the little green mark in the upper left corner. The dropdown arrow shows "number stored as text." When I then choose "convert to number" the number converts from text to number, which is what I want. But I don't have time to manually change each of the 6,000+ cells. If I highlight several cells, and do Format/Cells/Number/Number, the green mark in the upper left corner remains and the numbers in the cells are NOT converted to numbers but remain as text. Is there a way to globally change all numbers from text to number without having to manually do it one cell at a time? Thanks, I use a free tool called ASAP utilities. I find it very useful. It does dozens of everyday functions easily. http://www.asap-utilities.com/ Standard disclaimer no association, no profit from yada yada. gls858 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is Access even the right idea? | BMB | New Users | 19 | November 21st, 2005 08:01 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |