Hello,
I have a macro that works in an Excel worksheet, but when copying to a google doc, it does not. I am hoping that I can get help with converting the macro to work in google docs.
Here is the macro that works in Excel.
Sub ConvertRunNumber()
For x = 1 To 8000
RunNum = Cells(x, 1).Value
Newrunnum = Left(RunNum, 8)
Cells(x, 2).Value = Newrunnum
Range("B2").Value = Newrunnum
Cells(x, 2).NumberFormat = "0"
Next x
End Sub
Here is the macro in google docs that fails.

Syntax error: SyntaxError: Unexpected identifier 'ConvertRunNumber' line: 2 file: Missing Numbers.gs