Respected,
Though value() formula and isnumber() shows it was correct. The record was not recognised.
Is there any formula to find format of a cell(like dd-mmm-yy hh:mm Example: 8-dec-2021 11:20)
Zohar Batterywala
Respected,
Though value() formula and isnumber() shows it was correct. The record was not recognised.
Is there any formula to find format of a cell(like dd-mmm-yy hh:mm Example: 8-dec-2021 11:20)
Zohar Batterywala
Give few lines of example data and the expected result
Formatting has nothing to do with the underlying value. It is merely the way XL shows this value to the outside world ( be it on its own or through user manipulation).
By all means post a sample sheet with some data
Respected,m
Thank you for trying to help me.
will post a sample sheet with data by today or tomorrow(20jan or 21jan)
Zohar Batterywala
Don’t have an account yet? Register yourself now and be a part of our community!