Need Macro to Convert Text To Numbers in Multiple Sheets

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need Macro to Convert Text To Numbers in Multiple Sheets

FAQ

Thread Tools

Display Modes

04-11-2016, 01:41 AM

macropod

Windows 7 64bit Need Macro to Convert Text To Numbers in Multiple Sheets

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Please clarify your requirements. Your thread title suggests you want to 'Convert Text To Numbers', but the body your post indicates only a desire to change the formatting of a range of cells. Converting text to numbers and changing number formatting are two entirely different things - though both can be done in the one macro.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to convert text to endnote?	Orifacious	Word VBA	27	03-29-2022 02:58 PM
Macro to replace Image, Numbers in Table and in multiple protected word document	balaji	Word VBA	10	03-24-2016 02:11 AM
I need to convert shaded text into highlighted text on about 80 different long documents. VBA macro?	AustinBrister	Word VBA	8	05-28-2015 02:42 PM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM