recognised

Hi. :) The date the Monthview brings back onto my sheet is not recognised as a date. So when I try to look up the date to name the tab it isn't recognised. I have tried the following Selection.NumberFormat = "DD/MM/YYYY" And Application.SendKeys "{F2}", True Application.SendKeys...

Hello I have a problem whereby I have to copy data from my work system into excel and then run a vlookup againt the data. The problem is that the data is not recognised by the vlookup formula in all cases. the data is part numbers, and is a mix of numerical and alpha numerical. eg 30524 30536...

Hi, New to this forum as I cannot work out how to solve an issue that I have come across since we migrated our corporate email system from Lotus Notes to Office 365. Mr Excel has helped me a lot, by reviewing other peoples problems and proposed solutions, but I cannot find anthing on my...

Greetings I am attempting to determine a method of jumping to the first row of the next page, where the page breaks are automatically generated by Excel (A4 page size, automatic height/width). I figured it would be possible to do this by comparing the current row with data from vPageBreaks in...

I have tried to convert a formula in excel for Access but it is not being recognised. Excel formula is: =DATE(MID(F1,7,4),MID(F1,4,2),LEFT(F1,2)) Converted to: Date(MID([Bookings data]![date],7,4),MID([Bookings data]![date],4,2),LEFT([Bookings data]![date],2)) Issue is my data has what looks...