Forum Discussion
Date and Time value in cell is different from Formula Bar
Hello, I am working on csv file which has datetime column. When I selected a cell from that column, I see different format and number in Formula Bar than in the cell. I am using cell F2 as exam...
Date/time values always appear in that format in the formula bar. It is hard coded and can't be changed.
However the number format in cell F2 can be changed.
If you switch to General you will see a decimal number above 40000.