Forum Discussion
Solved
Cell formatting
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
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
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
That did the trick......thanks much.
StanZ0712 , you are welcome