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

04-11-2016, 04:57 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,521

Changing the number format for all sheets is as simple as:

Code:

Sub FormatNumbers()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
  ws.Range("D6:F385").NumberFormat = "###000"
Next ws
End Sub

__________________
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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:07 PM.