Posted to microsoft.public.excel.misc

frenchtoast frenchtoast is offline

external usenet poster

Posts: 11

How to convert text to number?

I have rows of data.

ie. '12345
and I want to use vlookup using number value 12345.

There isn't an error message (with pull-down arrow) to convert this '12345
into a number.

How do I convert this without having to manually change these cells?

Thanks!

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
convert text to number	Tom	Excel Discussion (Misc queries)	2	October 30th 08 06:15 AM
Convert Text to Number	Abdul Shakeel	Excel Discussion (Misc queries)	1	September 3rd 08 08:31 AM
Convert text number to number formate	[email protected]	Excel Discussion (Misc queries)	2	April 9th 07 10:48 AM
convert text-format number to number in excel 2000%3f	Larry	Excel Discussion (Misc queries)	1	July 29th 05 08:18 PM
not able to convert text, or graphic number to regular number in e	knutsenk	Excel Worksheet Functions	1	April 2nd 05 08:41 AM

All times are GMT +1. The time now is 08:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us