Thread: [Solved] Convert text to number help
View Single Post
 
Old 01-04-2023, 02:43 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
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;"$";"");".";",")
, and copy it down.

Edit: I see Pecoflyer adviced practically same!
Reply With Quote