Microsoft Office Forums - View Single Post - [Solved] Convert range format to number

Thread: [Solved] Convert range format to number

View Single Post

Old

07-26-2018, 08:42 PM

kevinbradley57 kevinbradley57 is offline

kevinbradley57 is offline

kevinbradley57 uses Windows 7 64bit

Windows 7 64bit kevinbradley57 uses Office 2010 64bit

kevinbradley57 uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Jul 2017

Posts: 87

kevinbradley57 is on a distinguished road

Default

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"

Reply With Quote