COLUMN l A has text format
and put tick mark through macro

if i put Cell(1, "A") .VALUE = "Ö"
but it put the same vlaue "Ö" here instead tick mark.
pl help.