Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 12-19-2019, 11:42 PM
levraininjaneer levraininjaneer is offline Reliable way to convert text to number with a formula Windows 7 64bit Reliable way to convert text to number with a formula Office 2013
Novice
Reliable way to convert text to number with a formula
 
Join Date: Dec 2019
Posts: 3
levraininjaneer is on a distinguished road
Default

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
Reply With Quote
 

Tags
conversion, text, value_function



Similar Threads
Thread Thread Starter Forum Replies Last Post
Reliable way to convert text to number with a formula 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
Reliable way to convert text to number with a formula 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:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft