Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-14-2024, 11:28 PM
Pablo2000's Avatar
Pablo2000 Pablo2000 is offline Excel after a MS update Windows 11 Excel after a MS update Office 2021
Advanced Beginner
Excel after a MS update
 
Join Date: Dec 2023
Posts: 73
Pablo2000 is on a distinguished road
Default Excel after a MS update

I have a value in cell B21 stating a time of 7:00. This cell is formatted as hh:mm. If I click in the cell and got to the edit bar. I then double click on the hour ‘07’ [Which turns black now] and change the value to 08. I should get 08:00 in that cell. Instead, I get



‘12/08/2024 08:00’ This is because the cell has re-formatted the cell now to dd/mm/yy hh:mm
I am sending the before and after spreadsheet.
I have repeatedly clicked on the whole column ‘B’ and formatted the entire column to ‘hh:mm’ This has never happened before. This seems to be after a latest MS update.

Is there a solution to this or do I now have to repeatedly reformat the cells daily.
Attached Files
File Type: xlsx Test.xlsx (23.1 KB, 5 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Update all 150 Excel links in Powerpoint at once sundk022@gmx.de PowerPoint 0 11-09-2021 09:00 AM
Excel after a MS update Word Doc Update from Excel Spreadsheet jmattingly85 Word VBA 4 08-09-2017 10:13 PM
Automatic Update for Excel Spreadsheet Frenchy305 Excel 3 07-14-2017 12:17 PM
Excel after a MS update How to update source excel file with changes made to insserted excel file in OneNote winwell OneNote 1 11-03-2015 12:19 PM
excel update superscript by 1 htownpaper Word 8 12-08-2014 06:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft