Apr 23 2019 09:36 PM
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
Apr 24 2019 04:07 AM
@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..
Apr 24 2019 04:20 AM
@StanZ0712 , that's strange, there is nothing hidden in formatting. Could attach small sample file?
Apr 24 2019 02:26 PM
Solution
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
Apr 24 2019 02:26 PM
Solution
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