Apr 16 2019 03:28 PM
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
Apr 16 2019 03:53 PM
Hi John,
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
General;General;""
Apr 16 2019 04:02 PM
@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
Apr 17 2019 03:52 PM