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

FAQ

Mark Forums Read

Thread Tools

Display Modes

12-19-2019, 09:55 PM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

Reliable way to convert text to number with a formula

I noted that the sheet in the uploaded file is named Feuil1 so I guessed that OP is French and therefore uses comma as decimal separator instead of dot. If I guessed correct I think my proposal will work.

Tags

conversion, text, value_function

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:42 AM.