Posted to microsoft.public.excel.worksheet.functions

Dylan @ UAFC[_2_] Dylan @ UAFC[_2_] is offline

external usenet poster

Posts: 76

Convert Text to numeric Value

I am trying to convert a string of text into a numeric value.
Ie,

I have several code legends to report results that need
to have a money value.
H1=154.00
H2=254.00

I would like to be able to type either of these code legeds in say A1
and then they will return the numeric value in say A45

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to convert a numeric value in text	how to convert a numeric value in text	Excel Worksheet Functions	2	August 21st 08 06:40 PM
Convert text to numeric value	Dylan @ UAFC	Excel Discussion (Misc queries)	1	May 15th 08 12:36 AM
Numeric in Text to convert back to the form of Numeric for VLookup Purposes	achilles	Excel Discussion (Misc queries)	4	February 6th 06 07:05 AM
Convert Numeric into Text	Monty	Excel Worksheet Functions	0	December 18th 04 09:25 PM
convert numeric to text	sahas	Excel Worksheet Functions	2	November 4th 04 10:08 AM

All times are GMT +1. The time now is 09:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us