|
|
#7
01-04-2023, 02:43 AM
|
|||
|
|||
As you want comma as decimal delimiter, I assume you use some European regional settings. So use in row 5 the formula
Code:
=1*SUBSTITUTE(SUBSTITUTE(D5;"$";"");".";",") Edit: I see Pecoflyer adviced practically same! 
|
|
|
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