General

date format
Hi all, I have a problem with date formatting. i have the following dates in MM/DD/YYYY format: 4/1/2010 4/2/2010 04/15/2010 when i tried to re-format the date, the 1st 2 column is formatted sucessfully but the last date will always remain unchange no matter what format is selected. Can anyone please ex... 16 Mar 2010 03:33

Extracting Data from a list into a schedule
Basically I am looking to take data from a list and have it automatically place itself into a schedule. The data would be extracted and placed based on the date the work is to be performed and then by the crew to perform the work. Ideally I would like it to be able to fill in based on hours associated with th... 16 Mar 2010 10:16

Change format
Hello Is there a way to change the following in hh:mm:ss? Instead of 22.14.15, I want it to change it to 22:24:15 (replace dot with colon?) I have few hundred entries which need to be changed. It will be too time consuming to change manually. Thank you 22.24.15 01.53.59 07.30.19 15.31.13 ... 15 Mar 2010 15:51

Change format
... 15 Mar 2010 17:01

Formating tenths and hundreds to show as whole numbers
I have a need to show the difference between percents as a change in points. For example, if a metric changes from 90% to 94% (+.04), I would like to display the .04 as +4pts. Is there a way to do this via formating? ... 15 Mar 2010 17:01

dowloading data of CSV file to excel file
Hi, I have the CSV file with more that 200000 lines and I need to import it into the excel sheet. I have tried using Import wizard and it did not work. I am using the Excel 2003. Please let me know the other way I can import the complete data to the excel. Regards, Igneshwara Reddy ... 15 Mar 2010 15:51

Sharing Violation
I have a new computer and the latest microsoft Excel. Whenever I try to save a file, I get a message that I can't save it because of a sharing violation. I created the file, why can't I save it? Carolan ... 15 Mar 2010 14:39

Calculate time difference
Hi I keep getting error when calculating time difference between Column E and Column C. I get the error #value. How can I fix this and get actual time difference between two columns. Time is military style. Thank you Column C Column D Column E 10.48.27 28-Feb-10 15.06.11 19.19.12 28-Feb-10 22.40.36 22.0... 15 Mar 2010 15:51

MS Query results into merged rows
Hi, I am using Excel 2003 on Windows XP with SQL Server 2005, I am using Ms Query to return a set of data and want it to go into a range of cells. However the cells are merged and the MS Query results unmerge the cells. Is there any way in which to preserve the cell merging? Regards ... 15 Mar 2010 14:39

Converting Date 03/01/2010 into a simple Month
Is there a way to convert a numeric date 03/01/2010 into a single month function? I have a worksheet that pulls in data from another worksheet, and column A has a numeric date of 03/01/2010. Want to put a statement in column B or where that only shows the month instead of the whole date field. ... 16 Mar 2010 11:25