Automatic Time Entry

A

Amanda

Hi there, I'm trying to enter time codes for a DAT tape in Excel and
everytime I do, it turns it into an actual time of day (am/pm). This is
screwing up my charts and I can't seem to turn it off. Help!?!
- Amanda
 
M

macropod

Hi Amanda,

If you pre-format the cell as text (Format|Cells|Number > Category), the entry will be stored as input.
 
A

Amanda

macropod said:
Hi Amanda,

If you pre-format the cell as text (Format|Cells|Number > Category), the entry will be stored as input.

--
Cheers
macropod
[MVP - Microsoft Word]


Amanda said:
Hi there, I'm trying to enter time codes for a DAT tape in Excel and
everytime I do, it turns it into an actual time of day (am/pm). This is
screwing up my charts and I can't seem to turn it off. Help!?!
- Amanda
Click to expand...
Click to expand...



Awesome, thanks!
 
Top