|
|
#16
01-05-2023, 03:06 AM
|
|||
|
|||
Quote:
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 
|
|
|
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 |
Convert text to number help
Windows 8 
Office 2016
Threaded Mode