Thread: [Solved] Convert text to number help
View Single Post
 
Old 01-05-2023, 02:25 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,387
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