Fix Date format as YYYYMMDD

[AAS44]

Hi there, I want to fix the format of a range of cells as date with this formatting: "YYYYMMDD" and no texts are supposed to be allowed.
I also want this formatting to hold true if a user inserts a new row below "G12". Any help would be greatly appreciated. Thank you

Please Login or Register  to view this content.

[ikboy]

Try this:

Please Login or Register  to view this content.

[AAS44]

still not workable..

[AAS44]

Hey sorry, its not working cause when i type 19990807 for example, it shows me an error "This value doesnt match the data validation restrictions defined for this cell"..

Try this:

Please Login or Register  to view this content.

[ikboy]

Numeric length 8 is not a date value.
For example 2019/08/15 the date value is 43692
If you want to control the length of numeric must 8 digital, uses below codes.

Please Login or Register  to view this content.

[Akuini]

Hi, AAS44
Is there any particular reason why you use 'yyyymmdd'? I mean why not use "-" or "/" as we usually do?

[jindon]

To Worksheet code module

Please Login or Register  to view this content.