Jambruins

Posts: n/a

Question about using the right or left formula

How do you get excel to recognize the data as a number when using the right
or left formula? For example, cell L73 has the following formula:

=RIGHT(D3,5)
The data this equation produces is +137. I have another cell that has a
formula that says =IF(ISNUMBER(L73),L73,"NO"). The answer I get is NO. I
should get +173. I have formatted cell L73 to be a number.

How do I fix this formula? 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
Formula question	Craig Fletcher	Excel Worksheet Functions	2	June 24th 05 03:58 PM
formula question	Pam Coleman	Excel Worksheet Functions	9	April 11th 05 08:51 AM
"IF" formula question	Barb1	Excel Worksheet Functions	2	April 5th 05 05:27 PM
time formula question...	Greg	Excel Discussion (Misc queries)	5	February 25th 05 10:11 AM
SUM array formula question	Dan	Excel Worksheet Functions	6	November 8th 04 05:49 AM

All times are GMT +1. The time now is 06:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us