Cell formats kep changing to "Time"

  • Thread starter Thread starter Excel
  • Start date Start date
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...
 
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
 
Do those cells have formulas in them that perhaps reference other cells that
are formatted to time - like in a time sheet?
 
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??
 
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??
 
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.
 
Back
Top