Convert range format to number

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

07-30-2018, 08:34 AM

p45cal

Windows 10 Convert range format to number

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

try:

Code:

With sht.Range("K2:N" & LR)
  .NumberFormat = "General"
  .Value = .Value
End With

You don't seem to have assigned anything to lastrow, but you have assigned something to LR.

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 12:35 AM.