Convert text to number help

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

01-04-2023, 05:42 AM

Haha88

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

Quote:

Originally Posted by macropod

Why use VBA at all, when you use a simple formula on each row:
=VALUE(D5)
with whatever regional cell formatting you require?

Thank you for your help. For some reason, value formula doesn't work as it returned as#value! error.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 01:51 AM.