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

Thread Tools

Display Modes

12-20-2019, 12:09 AM

macropod

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

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,369

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

conversion, text, value_function

« Previous Thread | Next Thread »

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 08:39 AM.