Convert text to number help

		Microsoft Office Forums > Microsoft Excel > Excel
Convert text to number help

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-03-2023, 09:37 AM

Haha88

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

Convert text to number help

Hi,

I would like some help creating a formula where I can extract the number from the cell and convert it to number form so sum can be added.

I attached the data and the expect result.

Many thanks,

Attached Files

Convert text to number form.xlsx (9.3 KB, 9 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 PM.