if A1 contains A56
in B1 =right(A1,2)*1 will return 56
in C1 =B1-4 will return 52
So instead of =Value(56) try =56*1
if A1 contains A56
in B1 =right(A1,2)*1 will return 56
in C1 =B1-4 will return 52
So instead of =Value(56) try =56*1
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks