Home |
Search |
Today's Posts |
#1
|
|||
|
|||
in Excel 2000 how do I convert text to numbers?
I imported files from Wells Fargo and I want to convert them from text to
numbers...so far nothing is working! thanks |
#2
|
|||
|
|||
Jo Dee
One method...... Format all as General. Copy an empty cell(also formatted as General). Select range of numbers. EditPaste SpecialAddOKEsc. One other method......... Select range of numbers and DataText to ColumnsFinish Gord Dibben Excel MVP On Sun, 27 Feb 2005 11:53:06 -0800, Jo Dee <Jo wrote: I imported files from Wells Fargo and I want to convert them from text to numbers...so far nothing is working! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
can i convert numbers to written text in excell 2003? | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |