ExcelBanter - Automatic Time Entry

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Automatic Time Entry (https://www.excelbanter.com/excel-discussion-misc-queries/198289-automatic-time-entry.html)

Amanda

Automatic Time Entry

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

macropod[_2_]

Automatic Time Entry

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" wrote in message ...
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

Amanda

Automatic Time Entry

"macropod" wrote:

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" wrote in message ...
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

Awesome, thanks!

David Biddulph[_2_]

Automatic Time Entry

Format to 24hr format, rather than 12hr format.
--
David Biddulph

"Amanda" wrote in message
...
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

All times are GMT +1. The time now is 02:31 AM.