Thread: Attendance table Text Value Convert to Number
View Single Post
 
Old 11-08-2018, 01:29 AM
NickFazer NickFazer is offline Windows 7 64bit Office 2003
Novice
  
Join Date: Sep 2018
Posts: 8
NickFazer is on a distinguished road
Default
Quote:
Originally Posted by NBVC View Post
something like..


=MID(A2,2,10)+0


or if it is always 1 digit, then..


=RIGHT(A2)+0



where A2 contains the original stirng like E2...
Many Thanks The Formula Guy, works great.

Reply With Quote