Posted to microsoft.public.excel.worksheet.functions

Michael Plog Michael Plog is offline

external usenet poster

Posts: 3

Cannot get VALUE function to work with cell references

I have a spreadsheet that has numbers entered as text. (I don't know
why they did it!) I want to convert these to numeric values so I can
sort properly, add, etc. When I use =value(L2) I get an error. Can
anyone help?

Thanks,
Michael Plog

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
Need some comments on my Utility_Move class module.	jchen	Excel Worksheet Functions	0	August 21st 06 07:05 PM
numerical integration	integreat	Excel Discussion (Misc queries)	4	May 12th 06 02:40 AM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
Copy cell format to cell on another worksht and update automatical	kevinm	Excel Worksheet Functions	21	May 19th 05 11:07 AM
Syntax for inferred cell references	donesquire	Excel Worksheet Functions	4	April 4th 05 09:29 PM

All times are GMT +1. The time now is 11:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us