Hi khank,

Have you tried these two tricks?

If your data is in A1 then in A2 put the following formulas.

1. To force a number to text do a = A1 & ""

2. To force text to numers do a = A1 + 0

What happens to your display of data?

Did that help?