Reliable way to convert text to number with a formula

xor · #1 12-19-2019, 09:55 PM

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.

levraininjaneer · #2 12-19-2019, 11:42 PM

Hi xor

Yes, I think your solution does address this problem well.

And well spotted

The trouble is that this sheet might be used either in France or outside of it, and I don't want it to break when opened on a non-French PC. Any ideas on how to make the solution robust? Can I set the "Region settings" on a sheet to not change when opened on another PC? (I will post another question about this...)

Best regards
P

macropod · #3 12-20-2019, 12:09 AM

Quote:

Originally Posted by levraininjaneer

The trouble is that this sheet might be used either in France or outside of it, and I don't want it to break when opened on a non-French PC. Any ideas on how to make the solution robust?

The solution I suggested is nothing if not robust.

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