Diane13

Posts: n/a

How do I multiply a unit measurement?

For example: 156 SQFT x $10.00. Where 156 SQFT is all in a single cell.
Is there a way to ignore the alpha characters and only look at the numerical
characters in the formula? (Excell 2000)

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
multiply time and wage	KC	Excel Discussion (Misc queries)	2	September 14th 05 08:11 PM
multiply time and wage	TomHinkle	Excel Discussion (Misc queries)	0	September 13th 05 10:29 PM
Use a measurement abbreviation in cell with formula	construction_secretary	Excel Discussion (Misc queries)	4	June 9th 05 03:16 PM
Moving selected data	Stu-Gnu	Excel Worksheet Functions	6	March 11th 05 04:04 PM
multiply by actual number in cell	CJ Cerezo	Excel Worksheet Functions	3	November 29th 04 09:43 PM

All times are GMT +1. The time now is 10:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us