Nov 28 2018 01:54 PM
Column A
1511208013000
Column B has formula:
=left(A2,4)
I can also use =mid or =right and column B shows literally the formula not the result which should be 1511
any ideas
Nov 28 2018 07:12 PM
Hi @WHIT2
Do you have your spreadsheet in formula mode? Press Ctrl + ` (left of the number 1 key) and see if that helps!
Cheers
Damien
Apr 11 2019 07:24 PM
1. Make sure that the cell format not in 'Text' and should be 'General'.
2. If still you have problem, Press 'Ctrl + `'