Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

If you want to display the formula in cells instead of calculated results in an Excel spreadsheet, here is how you can do that. It is possible to show the used or applied formula and hide the actual ...

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. <BR><BR>Now I want to convert ...

Hello all. I've been working on this for awhile but I'm stumped and putting this out to 'The Hive'. I have a report that prices bonds in the old tick format (i.e 101-10 for 101 and 10/32nds). When in ...