Thread: [Solved] Convert range format to number
View Single Post
 
Old 07-29-2018, 08:25 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jul 2017
Posts: 89
kevinbradley57 is on a distinguished road
Default
What is the proper syntax to convert a cell in which a number is stored as text and a negative number is displayed in parenthesis e.g. "(145.50)" to a format in which a negative number is displayed with a negative sign prefix e.g. "-145.50"?

The code below gives me this Run-time error: Method 'Range' of object '_Global' failed.

Code:
With sht
    .Range("K2:N" & lastrow).NumberFormat = "General"
End With
Thank you.
Reply With Quote