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 |
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 |
All times are GMT +1. The time now is 12:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com