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
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Conditional Formatting values across tables
ChrisJP in Excel on
5 Replies