Attendance table Text Value Convert to Number

		Microsoft Office Forums > Microsoft Excel > Excel
Attendance table Text Value Convert to Number

11-07-2018, 12:02 PM

NBVC

Windows 10 Attendance table Text Value Convert to Number

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macros to convert text to Table	josia	Word VBA	3	08-28-2015 09:11 PM
Convert Text To Table: Separate text at (Other)?	tinfanide	Word VBA	2	01-12-2015 05:26 AM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM
Convert graphic to text in a table	Jennifer Murphy	Word	6	01-24-2013 12:56 PM
Convert Number to Text	devcon	Word	0	07-10-2010 01:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:47 AM.