Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 01-05-2023, 03:06 AM
ArviLaanemets ArviLaanemets is offline Convert text to number help Windows 8 Convert text to number help Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by macropod View Post
It worked for me just fine with the OP's worksheet...
And what are your regional settings? US?

I have European (more precisely Estonian) regional settings, and multiplying e.g. entry $129.42 with 1 returns $129.42 instead 129,42 - i.e. no conversion is performed!

In case you want to test it with US settings, edit the numbers in OP's table like 129,42 EUR, and try them convert to numbers like 129.42
Reply With Quote
  #17  
Old 01-05-2023, 07:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Convert text to number help Windows 10 Convert text to number help Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please mark thread as "solved". thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #18  
Old 01-05-2023, 02:25 PM
macropod's Avatar
macropod macropod is offline Convert text to number help Windows 10 Convert text to number help Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by ArviLaanemets View Post
And what are your regional settings? US?
AUS
Quote:
Originally Posted by ArviLaanemets View Post
I have European (more precisely Estonian) regional settings, and multiplying e.g. entry $129.42 with 1 returns $129.42 instead 129,42 - i.e. no conversion is performed!

In case you want to test it with US settings, edit the numbers in OP's table like 129,42 EUR, and try them convert to numbers like 129.42
Doubtless regional settings play a role, but the point remains the approach addresses the OP's problem.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Always convert text to number? SoMany Excel 1 04-26-2021 02:09 AM
Convert text to phone number in merge ChrisComp Mail Merge 1 03-03-2020 10:39 AM
Reliable way to convert text to number with a formula levraininjaneer Excel 8 12-22-2019 04:47 PM
Attendance table Text Value Convert to Number NickFazer Excel 2 11-08-2018 01:29 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 10:17 AM.


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