Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
text to numeric formatPosted by Rob on September 11, 2001 10:13 AM
I am having trouble converting a column of (text)numbers to numeric format. This is a table, copied from an HTML page and pasted into excel.
The column looks like this: (example)
I've tried re-formatting the column to no success. I need to do calculations with these numbers, but I cannot do them now.
|Check out our Excel Resources
Re: text to numeric formatPosted by Juan Pablo on September 11, 2001 10:20 AM
Have you tried the Value function ?
If your data beggins in A1, and copy down as needed.
Also... (Re: text to numeric format)Posted by Aladin Akyurek on September 11, 2001 11:45 AM
type 1 in an empty cell, copy this cell, select the range of interest, activate Edit|Paste Special, and choose Multiply in the Paste Special window. Delete the cell containing 1. Select the range which is now of numeric type and format it as currency if you so desire.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.