SyntaxFix
Write A Post
Hire A Developer
Questions
Indeed, just as commented by Tim Williams, the way to make it work is pre-formatting as text. Thus, to do it all via VBA, just do that:
Cells(1, 1).NumberFormat = "@" Cells(1, 1).Value = "1234,56"