Thread: Attendance table Text Value Convert to Number
View Single Post
 
Old 11-07-2018, 12:02 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
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...
Reply With Quote