Not being able to change the time format

May 7, 2013 at 08:10:45
Specs: Windows XP
I have my spreadsheets formatted to show time as, for example 11:30 AM or 1:30 PM by entering 11:30 or 13:30. Some of the cells will, instead, show 11:30:00 AM/1:30:00 PM. When I attempt to correct the format, from the time format drop down, it will revert back to the incorrect format.

See More: Not being able to change the time format

Report •

May 7, 2013 at 09:20:03
What happens, when selecting a correct formated cell, click the little brush from the toolbar, and then click a cell, which is incorrectly formatted.
The little brush is, to transfer format from cell or cells to other cell or cells in Excel.

Report •
Related Solutions

Ask Question