#16
|
|||
|
|||
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 |
#17
|
||||
|
||||
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 |
#18
|
||||
|
||||
AUS
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
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 |