Cell formats kep changing to "Time"

E

Excel

I am always changing my cell formats in one spreadsheet from time to
general. I have to keep doing this over and over. Why does my
spreadsheet keep changing cells' format to "Time"? I can't figure out
why this is happening...
 
G

Gord Dibben

Have you got any behind the scenes VBA code that formats the workboo/worksheet
to Time when you open the workbook or activate the sheet?

Do you get the macro warning when opening the workbook?

Alt + F11 to open Visual Basic Editor.

Look through your workbook Sheets and Thisworkbook modules for code.


Gord Dibben MS Excel MVP
 
R

RagDyer

Do those cells have formulas in them that perhaps reference other cells that
are formatted to time - like in a time sheet?
 
E

Excel

Do those cells have formulas in them that perhaps reference other cells that
are formatted to time - like in a time sheet?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
message



- Show quoted text -
Click to expand...

RagDyer - Yes - this IS a timesheet. But asome of the cells aren't
even formulas - just hard coded numbers (e.g. a "project code of 201
shows up as 12:00 AM. You must be on to something -- why do you ask??
 
R

RagDyeR

Have you tried formatting to Text?

Since they're project numbers, you're not going to calculate with them
anyway.

Text always works for me in such situations.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Do those cells have formulas in them that perhaps reference other cells
that
are formatted to time - like in a time sheet?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
message



- Show quoted text -
Click to expand...

RagDyer - Yes - this IS a timesheet. But asome of the cells aren't
even formulas - just hard coded numbers (e.g. a "project code of 201
shows up as 12:00 AM. You must be on to something -- why do you ask??
 
E

Excel

Have you tried formatting to Text?

Since they're project numbers, you're not going to calculate with them
anyway.

Text always works for me in such situations.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message


RagDyer - Yes - this IS a timesheet.  But asome of the cells aren't
even formulas - just hard coded numbers (e.g. a "project code of 201
shows up as 12:00 AM.  You must be on to something -- why do you ask??- Hide quoted text -

- Show quoted text -
Click to expand...

I have fornatted them to text. Usually I fformat them to "General" --
but it keeeps reverting back to time. The formulas aren't getting
ruined -- just the formatting. It's only annoiyng -- I have to keeep
reformatting to see teh project number (and many other cells). Sigh,
I could have bigger problens, but this is surely a mystery.
 
Top