Stubborn cell formatting.

M

m_joy

Hi

I am updating a general log sheet and having some seriously frustrating
formatting issues. It's a protected sheet which I have unprotected yet I'm
still unable to update the cell format. Though the properties say that it is
in the format I want - 13:30 - it is still displaying as mm/dd/yyyy hh:mm PM.
I've tried everything from clearing the entire contents of the cell to using
the format painter and I'm still at a loss. Any idea how to ensure that
formatting changes are applied? Any help offered would be greatly appreciated.
 
G

Gord Dibben

Perhaps the data is Text?

In an adjacent cell enter =ISNUMBER(cell)

True or False??

If False, run the data through Data>Text to Columns to see if you get a
change to General format which you can then re-format to time.


Gord Dibben MS Excel MVP
 

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

Extracting just the time portion 6
separating date and time 5
SUMPRODUCT to exclude text column header 1
Date and Time Conversion 3
Publisher is filling blank lines with data 2
Cell format will not update 1
typing in a new cell and carrying the formatting of the previous c 2
help with format change of date part of concatenate formula 1

Top