Need Help Please with Excel Formula

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
Same results. Tried in 2 empty cells.

=ISNUMBER(A2)



AB=ISNUMBER(A2)
1OriginalConverted
2116=SUMPRODUCT(MOD(MID(A2,{1;2;3},1)+5,10)*{100;10;1})
3787232
4234789
5278723
6109654

<colgroup><col style="mso-width-source:userset;mso-width-alt:3364;width:138pt" width="184"> <col style="mso-width-source:userset;mso-width-alt:5741;width:236pt" width="314"> <col style="mso-width-source:userset;mso-width-alt:8594;width:353pt" width="470"> <col style="width:191pt" width="254"> </colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
What do you mean by "same results"?
Are you saying that you cannot insert in a cell a very simple formula as =ISNUMBER(A2)? Is so, your Excel has problems.
By the way, what Excel version are you using?

M.
 

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
I mean it is not working when I place the = ISNUMBER command in an empty cell. I have suspected that Excel is not working correctly, so I have Excel 10 on the way.. I have Microsoft Home and Student 2007 version, as for the exact version # I looked in "properties and it does not give the exact version number ... Operating System is Windows 10. There maybe some compatibility issues.
 

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
I have determined that: The reason I can't get the formula to work is that I don't know how to copy and past the formula to my workbook. DID I MENTION THAT I KNOW VERY LITTLE ABOUT EXCEL LOL... Please tell me how to copy and past formulas.:eek:
Thanks again.
 
Last edited:

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
Your silence is deafing, thanks any way.
 

Lindee

New Member
Joined
Jan 27, 2018
Messages
24
The cell does nothing.... the formula just sits there in the cell
like this:
=ISNUMBER(A2)

<colgroup><col width="390"></colgroup><tbody>
</tbody>
 
Last edited:

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
This usually occurs when the cell is formatted as text. Select the cell, right-click, pick Format Cell, and choose General.
Type again the formula in the cell.

M.
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
It looks to me like you have a space in front of the formula in the cell where it is sitting, click on it and before the = sign, try either backspace or delete
 

Watch MrExcel Video

Forum statistics

Threads
1,089,778
Messages
5,410,363
Members
403,316
Latest member
samhadian

This Week's Hot Topics

Top