Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

text to numeric format

Posted 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)

$754.23
$1,553.29
$82.87
$856.34

I've tried re-formatting the column to no success. I need to do calculations with these numbers, but I cannot do them now.
Any ideas?


Check out our Excel Resources

Re: text to numeric format

Posted by Juan Pablo on September 11, 2001 10:20 AM
Have you tried the Value function ?

=VALUE(A1)

If your data beggins in A1, and copy down as needed.

Juan Pablo


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.

Aladin


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.