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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies