VBA convert working wrong

[Akbarov]

Hey community,

i use following formula to convert time to numbers.

[COLOR=#333333]Sub Convert()[/COLOR]
[COLOR=#333333]With Worksheets("DATA").Columns(10)[/COLOR]
[COLOR=#333333].NumberFormat = "0"[/COLOR]
[COLOR=#333333].Value = .Value[/COLOR]
[COLOR=#333333]End With[/COLOR]
[COLOR=#333333]End Sub
[/COLOR]

But for some reason it is working wrong, instead of converting it replace most of cells with column name. ( column name is HOUR )
Can anyone tell me why i get this result?

 

[JLGWhiz]

Cross posted: https://www.excelforum.com/excel-pr...vert-giving-me-wrong-results.html#post5208918

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1112106-convert-vba-working-wrong-post5354853.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).