>Dear sirs (or Madam Tamar)
>
>using excel automation, I am trying to format a number which is longer then 15 digits.
>for example: this tracking number "9405511899560508810804" will always render as "9405511899560500000000"
>I have tried several iterations of the following:
>
>lnTrackNo = len("9405511899560508810804")
>
>m.loExcel.Range([C2:C2])).NumberFormat = "0"
>m.loExcel.Range([C2:C2])).NumberFormat = "#"
>m.loExcel.Range([C2:C2])).NumberFormat = "Special"
>m.loExcel.Range([C2:C2])).NumberFormat = "Custom"
>m.loExcel.Range([C2:C2])).NumberFormat = Replicate([0],m.lnTracnNo)
>
>any suggestions would be greatly appreciated.
Don't use numeric, use text.