When I type 0 A in to a cell it automatically returns 12:00 AM. I have looked
through all of the formatting functions and cannot turn it off.

This is not a function you can turn on and off. It is a matter of cell
formatting (it's one of Excel's Time formats). Switch your cell formatting
to "Text" or, if you need to keep the current formatting, precede the 0 with
a single apostrophe(').

"Dazza" wrote:

When I type 0 A in to a cell it automatically returns 12:00 AM. I have looked
through all of the formatting functions and cannot turn it off.

Change the cell format to General


--
HTH

Bob Phillips

"Dazza" wrote in message
...
When I type 0 A in to a cell it automatically returns 12:00 AM. I have
looked
through all of the formatting functions and cannot turn it off.