Search results for query: *

Hello, i have a smartphone application that generates a XML file. this file contains a text field, a numeric field and a date field. i would like to link this file to an Excel. i have done this without any problem. however, i have a weird date field. in fact it is 18 characters long. when i...

alright i got what you are saying and it works great. please accept two stars for the two stars that you are :) Adnane Micorosft North Africa http://www.microsoft.com/northafrica

First, thanks a lot for your answers i am sorry if i misunderstood you or if it will sound stupid but you are talking about the time cell as ordinary Time Formatted cell. however, if i format it like this, it will not allow me to have a time period of 90 minutes for example so what i have done...

Hello, i would like to know if there is a function in Excel that will allow me to calculate a cost based a $/min and a duration Actually, my data looks like this Duration(min:sec) Minute Cost Total Cost ----------------- ----------- ---------- 90:15 2...

hello, i would like to know if any one has already a populated date dimension in MS sql server 2000. with the different attributes( week #, day #, week_day, day_in month, etc...). if not, does any one knows how to populate this dimension? thank you Regards Adnane Micorosft North Africa...

you could also select all the column, then press F2 to edit the cell. then go to the beginning of your string and add '0 and press Ctrl+Enter this would do the thing as well Adnane Micorosft North Africa http://www.microsoft.com/northafrica

i apologize, i didn't read very carefully what you were asking for. ISERROR will work indeed. Sorry :( Adnane Micorosft North Africa http://www.microsoft.com/northafrica

=if(isna(if(find("sign",A1),"eyes","")),"",if(find("sign",A1),"eyes","")) would work also if you want to control only the #N/A error Adnane Micorosft North Africa http://www.microsoft.com/northafrica

you can use B1=if(find("sign",A1),"eyes","") Adnane Micorosft North Africa http://www.microsoft.com/northafrica

if i got it right, you could maybe try this: say you will get the results on three columns. you could have on B1 =vlookup($A1,my_range,column(CS1),false) this way, if you drag the formula on the two other columns, you will get in B1 the the value in column 97, in C1 98, and in D1 99. Hope...

missinglinq, Please accept a star from me :) Adnane Micorosft North Africa http://www.microsoft.com/northafrica

Do you have other columns like City, Postal Code, Phone number? this way you could maybe create a key (it will be a combination of some characters from two or three field) that may help you match these two lists. it will obviously not be a 100% correct but it can significantly help you. Adnane...

Thanks a lot missinglinq, that's almost exactly what i need. however, i couldn't find a form that allows to input the daily sales made. all i could find was for order and supplies. Can you help? Thanks Adnane Micorosft North Africa http://www.microsoft.com/northafrica

Hi, i'm developing a small application using access 2003 to basically manage the inventory and sales of a shoes store. what i need this application is very basic: keep track of orders, purchases, sales, and generate some reports. does anyone know where i could find some useful...

an alternative would be to first create a new column that would contain only the names (without Task1,Task2...). you could use this formula =RIGHT(A1,LEN(A1)-FIND("-",A1)-1) Then you can use a pivot table to get all kind of statistics easily. Hope this helps Adnane Micorosft North Africa...

Good point Goeff. then a simple Pivot Table will do the thing. Adnane Micorosft North Africa http://www.microsoft.com/northafrica

Hi, you can get a notification window whenever a new mail arrives and the option to double click on it in order to open it. to do so, you need to go to Tools||Rules & Alerts||New Rule and then you should create a new rule of Type "Display mail from someone in the new Item window. then you would...

Hi Joe, if i understood you correctly your problem is when you enter for example 1 in A1 and you drag, it doesn't work unless you use the auto fill options right. have you tried to put 1 in A1 and 2 in A2, then select both cells and do your drag. this way you let excel know that it is a series...

Hi, Office XP Dev edition does not exist anymore. indeed, in order to use Office 2003, you will need to have Office + Visual Studio + Visual Tools for Office. Buying only the tools for Office will not help you unless you have Visual Studio. Hope this helps Adnane Micorosft North Africa...

Please accept a star from me Ken. Adnane Micorosft North Africa http://www.microsoft.com/northafrica