how to convert text obtained from formula to numbers

's Computer Specifications

I have obtained some figures using mid function, I want to convert them to
numbers.
I have lots of such values so cant convert manually.
I want some automated tool or function for this

's Computer Specifications

Try using the value command.

"A m o L" wrote:

> I have obtained some figures using mid function, I want to convert them to
> numbers.
> I have lots of such values so cant convert manually.
> I want some automated tool or function for this

's Computer Specifications

can't you just select all your data and press "f9", this will replace all
formulas with their results..

"A m o L" <A m o (E-Mail Removed)> wrote in message
news:95FF3E20-56CB-4FF0-B3A6-(E-Mail Removed)...
>I have obtained some figures using mid function, I want to convert them to
> numbers.
> I have lots of such values so cant convert manually.
> I want some automated tool or function for this

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I convert numbers stored as text back to numbers in MS Access	CUserM	Microsoft Access Queries	7	20th Jun 2008 08:12 PM
Convert numbers stored as text to numbers errors after loading data in	jobs	Microsoft Excel Programming	2	28th Mar 2007 02:57 AM
How do I write a formula to convert numbers to written text?	=?Utf-8?B?SmVzcw==?=	Microsoft Excel Worksheet Functions	2	25th Apr 2006 03:25 PM
Convert numbers stored as text to numbers Excel 2000	=?Utf-8?B?RGFybGVuZQ==?=	Microsoft Excel Misc	6	31st Jan 2006 08:04 PM
Is there a formula to convert numbers to written text in Excel?	=?Utf-8?B?TFpD?=	Microsoft Excel Worksheet Functions	3	27th Nov 2004 08:10 PM