thousand

Hi, I need a VBA code to delete the first 100 duplicates in column A and keep the remaining. There could be a thousand names that appear a thousand times, but would want to delete the first 100 duplicates that their name appear on this list and keep the remaining. Thanks, Mr Tran

Hey Everyone! I have a weird problem. We usually get reports in PDF-s and we convert them to excel. Column A contains a lot cells with one word or a number. I need to separate the numbers that have thousand separators from the ones that don't. The problem is that after the conversion these are...

This works in excel 97 -2003 but does not work in 2013 or 2016. I get a the #Name ? value. Will you review and see what needs to change to work in 2013 or newer? Function BOND(Subtotal, TaxRate) As Single 'Author Jim Hesh 'Set limits and...

Hello, I need to take multiple rows with same information as below: And organize in columns like this: I have a thousand of these to do and copying and pasting with transpose is not an option :(

My values in excel are comma seperated number values <tbody> <tbody> NUMBER OF ESTABLISHMENTS </tbody> <tbody> EMPLOYMENT </tbody> 91,365 1,603,567 738 6,410 </tbody> When I load this into Power Query the commas disappear. When I try to load it back into excel the number...

I want to automatically delete the thousand separator in this value. Can someone pls. help me with a Excel formula? 1.500.00

Hi all, the "spell" function works great, the only problem is , it doesn't fully resolve my problem. For the document i need to send to bank. I have few problems that i need to modify the code: As below e.g. 1. Usd 45612.00 . I need it to covert for me to " us dollars: Fourty five thousand six...

Hello All, I am trying to build a spreadsheet to generate sales commission if their production is over a certain amount. For instance, if they produce $1.25mil they get $1.25 per thousand dollars if it below $1.25mil it will be $1 per thousand. So if they do the $1.25mil their commission...

Hi Mr. Excel. How can i use SpellNumber without Dollar. example i write 1600000-One Million, Six Hundred Thousand,Only

Hi I have alot of data, that i need to convert. <tbody> value in system new value (the formula that i need) 8726,36 9000 8971,84 9000 56724,62 57000 7000,1 9000 846618,09 847000 </tbody> what i got so fare is =ROUNDUP(ODD((ROUNDUP(R3;-3)));-3) but it doesnt work i need the...

Hello, I am stucked here again: Can I ever convert numbers to words with a formula? Say $12345 I will want to get twelve thousand three hundred and forty five. Thanks Kelly