function to find out format

    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

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login