![]() The last example 12376 - there's no way of determining whether or not this is 23rd Jan 76 or 3rd December 76 - ie should string be 012376 or 120376? There's no way to determine (by length of cell string) where day, month, year starts I have to say that I don't think you can do this because the date strings are too ambigous.I extended your examples with some more _Įnd(xlUp).Row).SpecialCells(xlCellTypeConstants) Here's the macro as it stands.įor Each cell In Range("I2:I" & Range("I" & Rows.Count). I need help with is changing all the number formats to a dd/mm/yy format. The last two formats 251119976 do not copy or convert. In this respect cell J1 shows a value and only61176 convert to the required date format. Lastly converting the column format to dd/mm/yyyy and filling down. I then went on to cut the left, mid and right portions in order that 61176 became in the next column. It works to a point though 6111976 fails. What I tried to do was add the leading zero back to the number format. The sample data I have been working with is thus: ![]() I have ASAP Utilities but it does not quite cut it. I am trying to put together a macro that converts numbers back to a date format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |