Cell formatting

New Contributor

Trying to format cells for time (hh:mm) but when entering time, the =equals function also gets added and cannot clear this from the cell

7 Replies

@StanZ0712 , you don't need any equals, it's like



@Sergei Baklan I know that but the =  seems to automatically appear ....I do not enter it manually.  It's like there is a hidden = format somewhere in the file..

@StanZ0712 , that's strange, there is nothing hidden in formatting. Could attach small sample file?


@StanZ0712 ,


Please uncheck Lotus compatibility setting for this sheet


, done in attached file.

With them = is added and you have something like =6:30, which means reference on range from row 6 to row 30

@Sergei Baklan 

That did the trick......thanks much.

@StanZ0712 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies