this;

Good morning everyone, I have many numbers in excel which read like this; @01392293 I need the numbers to read like this; '@01392293', When I try to format the number to custom it reads the ' at the beginning but not the rest. I'm not sure how to do this? Any help is appreciated. Thanks

Hi, I use Excel to create journals that I then upload the problem with this is that it creates additional commas on some lines that I then have to manually remove, is there any VBA I can use that saves the sheet as csv pops up with the save as dialogue box but removes the excess commas? The...

I'm trying to find a way to get the financial year from a date - I currently have this; I need it to effectively give me the financial year from the date, (the financial year being from 1st April to 31st March). Is there a way I can do it? I don't mind if it's a formula or through VBA.

I have a range of numeric values currently between N2:N13 and I need those loaded into a Listbox using this; ListBox3.RowSource = Range(Sheet5.Range("N2"), Sheet5.Range("N65536").End(xlUp)).Address(, , , True) The issue is that it is only loading the first value, from N2 and nothing else. I'm...

I'm having issues trying to extract a number from a string. I've currently got this array formula; The issue is that there are various numbers at various points within the string and what I need to do is extract only the number which will always be on it's own, like this; In this case I'd...

The blue dot moves according to the average width. The formula looks like this; =IF([@Width]<10.7,LArrow,IF([@Width]>25.1,REPT(" ",34)&RArrow,REPT(" ",([@Width]-10.7)*2.42)&Dot)) I was just curious how something like this is done. <attachment></attachment><attachment></attachment>

Hi all, First time posting here about access so any help will be greatly appreciated. I'm creating a user-form in access and due to the remit given to me i,m trying to avoid as little code as possible so therefore i'm trying to set some validation for a text box. it shouldn't be that...