>Hi all,
> i wirte a export excel , but i don't know why if the value is numberic , then it will auto algin right in excel .........
>i try any method but i can't algin left.......... Anyone know how can i do , please ?
>
>

>oRng = Sheet.Range("C1 ","C1")              
>                oRng.HorizontalAlignment = 1
>                oRng.VerticalAlignment = 1
>                oRng.EntireColumn.AutoFit()
>
>  Sheet.Range("C1").Value = "5"
>

Prepend a single quote to the value

>  Sheet.Range("C1").Value = "'" +  "5"