Search results

Hi Excel Gurus, i have question, how to automated leading zero in my excel ? example ;- 1 12 123 1234 12345 i would like the result to be :- 0000000001 0000000012 0000000123 0000001234 0000012345 i don't want to use format cell /custom as the solution, because after i add leading zero i...

Hi Excel Gurus, can u help me on this problem cells A1 = 1 cells B1 = 2 cell C1 = 3 Result 1 = 2 = ABC 1 = 3 = DEF How do i get ABC if 1(A1)=2(B1) ? do i need to create table for referring ?

Hi Excel Gurus, is there any formula that can be use to automatically put 10 character in records example : Cells A1 = 123 - add 7 space (using space bar) at the end of record. Cells A2 = 1234 - add 6 space (using space bar) at the end of record. Cells A3 = 12345 - add 5 space (using space...

Hi i have 2 column jun2010 and july2010, this column contains values that i need to plus, after get the values i need to divide by 2. how to do that in access 2007 example ;- Item----Jun2010----July2010----Total Jun+Jul/2 ABC-----56---------40-----------48 the 48 come from (56+40)/2

Hi all, this doesn't seem too complex but I'm having trouble finding a similar situation online. I have a query with a field called MAD. I would like to turn these MAD into a category index. For example: MAD: Number of MAD-> assigned Category value. 0-50 -> A 51-100 -> B 101-500 -> C...