Reliable way to convert text to number with a formula

		Microsoft Office Forums > Microsoft Excel > Excel
Reliable way to convert text to number with a formula

12-19-2019, 01:49 PM

NoSparks

Windows 7 64bit Reliable way to convert text to number with a formula

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Did adding zero to the value not work?
=VALUE(B2)+0

12-19-2019, 05:48 PM

xor

Windows 10 Reliable way to convert text to number with a formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

This might be of help.

Attached Files

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to convert dates into text/values	Marcia	Excel	2	07-01-2019 06:53 AM
Attendance table Text Value Convert to Number	NickFazer	Excel	2	11-08-2018 01:29 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 Formula Result to Static Text	MYGS	Excel	16	01-21-2013 08:18 AM
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 03:30 PM.