When I type in 0 A to a cell it returns 12:00 AM. Need to turn off

D

Dazza

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.
 
S

SVC

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(').
 
Top