Forum

Hi Pete, When you write a reply in the forum, underneath the area you are typing in is a button named 'Attachments'. Click that, and attach and up...

Sure, Open the VBA editor and modify the last line of the NumToWords function to this NumToWords = Application.Trim(Units & SubUnits) & ...

Hi Peter, If you can attach those sample files we'll take a look at what we can do for you. Regards Phil

Hi Liesl, The first thing that pops out is that you've asked VLOOKUP to return the 4th column but your data is only 1 column wide. Also, I presu...

Hi Salim, Concatenate " only" to result the function returns: =numtowords(A2) & " only" Regards Phil

Hi Pete, We can't give you an accurate answer without seeing your data, please supply the workbook, criteria etc. Do you have Office365? If so ...

Hi Salim, Please read this post and use the code from it Regards Phil

Hi Bill, Please start your own topic rather than adding to an existing topic that is not related to your problem. You can follow these instruction...

Hi Jacek, If there's more data to work with then you need to supply it please. And provide detailed examples of the expected results for this da...

Hi Mohith, The attached file will do what you want. I've modified the message body as it didn't need the time in the string, I'm picking that ...

Hi Jacek, If that is all the data you will be working with you can just use an IF. There are only 2 possible outcomes "Linux" or "Windows" and the...

Hi Josia, Please post a workbook when you ask a question so we don't have to recreate your workbook. It also makes it harder for me to visualize e...

no worries 🙂

Hi Scott, It's always best to supply your workbook so we don't have to recreate it. Times and dates are stored as serial numbers in Excel ...