I have an application that generates a file that include VLOOKUP formulas, but the result is not calculated automatically. I need to manually press F2 + Enter to have the result calculated.
Facts:- I already set: Formulas > Calculation Options > Automatic- B6:B17 and B19:B26 have the "General" format- B28:30 and B32:34 have the "Numeric" format
The final idea is to print the text only, not the number zero
Here is a copy from the file:https://drive.google.com/drive/folders/1ai_bHPXqfyZSQeSfUN8XcEIJz4fX7gqh?usp=sharing
I see no problems with your file, it is calculated automatically if add any data in Settings.
To hide zeroes you may apply custom format
@Sergei Baklan Really? what I see in computer is this: https://drive.google.com/file/d/14_aiRSQiCBsGNKNyqcsFQlPDXtUqmRWu/view?usp=sharing
And the expected result would be actually B6="1 day, 2 hours" and so on
@John_P_ , that's my screen