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!