Microsoft Office Forums - View Single Post - [Solved] Convert text to number help

Thread: [Solved] Convert text to number help

View Single Post

Old

01-04-2023, 05:37 AM

Haha88

Haha88 is offline

Haha88 uses Windows 8

Windows 8

Haha88 uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Mar 2015

Posts: 79

Haha88 is on a distinguished road

Default

Quote:

Originally Posted by Pecoflyer

View Post

With US regional settings

Code:

=SUBSTITUTE(D5,"$","")+0

With European regional settings

Code:

=SUBSTITUTE(SUBSTITUTE(D5;"$";"");".";",")+0

Thank you for your help. Substitute works brilliantly.

Reply With Quote