what format do you want then?
you've lost me!
text has no format as such just shows exactly what you put in cell.
so what bit of auto formatting do to want to turn off?
i.e what is it thats going wrong?