Automatic Time Entry

  • Thread starter Thread starter Amanda
  • Start date Start date
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
 
Hi Amanda,

If you pre-format the cell as text (Format|Cells|Number > Category), the entry will be stored as input.
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open specific hyperlink (accept) automatically in email with outlook 0
automatic time formatting 3
Entering a time into excel 10
Determine if night shift by start & end time 2
Making weekend days working days - the system cuts the working tim 1
Comparing Time in a Formula 1
entering current time in shared work book - 2003 1
time entry-excel 1

Back
Top