Convert range format to number

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Convert range format to number

07-26-2018, 08:42 PM

kevinbradley57 kevinbradley57 is offline

Windows 7 64bit Convert range format to number

Office 2010 64bit

Advanced Beginner

Join Date: Jul 2017

Posts: 87

Convert range format to number

I need the right syntax to convert the format of a range to "number". Here is my attempt:

Code:

Range ["K2:N" & lastrow].NumberFormat = "0.00"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format a range of cells	Dave T	Excel Programming	1	06-01-2016 08:58 PM
How to format a TOC (level 1) using a number, but have the number hidden in the text	porpoiseoil	Word	1	09-13-2014 12:53 PM
IF statement - number range	irhut	Mail Merge	1	02-11-2014 11:20 PM
Change from General Format to number format	gbaker	Excel	3	08-16-2013 01:04 PM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 PM.