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-22-2019, 04:47 PM

p45cal

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

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

In your french workbook perhaps:

Code:

=IFERROR(VALUE(B3);VALUE(SUBSTITUTE(B3;".";",")))

I think the formula semicolons automatically get changed to commas if opening it in an English version of Excel.
edit:
Or perhaps:

Code:

=SIERREUR(CNUM(B3);CNUM(SUBSTITUE(B3;".";",")))

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 12:21 AM.