formating

Could someone help me please. Below is an example entry in a single cell. I am parsing the different elements out into separate columns. 16 Aug Payment to xxx Type of payment yyy Amount £zzz<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The...

Hi guys, Hope you can help !! I'm writing a log to combine 4 teams data entries. Team Red, Team Green, Team Blue and Team Yellow. There are 30 data feilds and only certain ones apply to each team. I wish to put a drop down column in A for the 4 different teams , If I select a certain team...

I have a spreadsheet that list repairs for parts. I would like to build a pivot table that show the top 20 most profitable margin repairs by part # (Column G) and description (Column J) with the percentage of warranties (Column E) for those repairs. I am using Excel 2007 but I am not sure what...

how can I not allow user to remove date from "10/1/2010 9:15 PM" format....current code in cell in date & " " & time. Some user edit the time and in the mean time remove the date and leave only the time which I dont want to happen. Allow user to change the date and time too but always force...

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Hope you can help me cus i been everywhere and tried everything already.<o:p></o:p> <o:p></o:p> i need to convert all the numbers in a sheet from text to number format so it would do the...

I've got a macro written that reads the values of two columns into an array. The first column is either blank or an "x", it is a selection column. The second column has topic titles in it. The macro outputs a condensed list of all those topics "selected" but having an "x" in the column to the...

Problem: I am working with a file in Excel 2007, compatibility mode because some users still have excel 2003. Created table where columns have formulas that return a 1 or a blank. I created a pivot table from the data where the column values with 1 are conditionally formatted with green fill and...

We rececently added an SAP expense forecasting tool, which runs using Excel. While the tool is still being developed to forecast, I am using SAP & hard-keying in data to create a actuals+forecast view. Trouble is, when I "refresh" the SAP app. all of the data I hard-keyed in changes (this is...

1) When I reference another workbook, I simply hit "=" and then the cell on the other workpaper I am referencing. The cell i'm trying to pull information from is all words/text. Anyway, when I complete this task, sometimes it will just show "####################" in my target cell, what is going...

Hello all! I am building a spreadsheet with several columns (A to AH) and in the last one (AI) I have a checkbox with different statuses (approved, rejected, etc). I want all the cells of the row be colored when I select the status approved. How can I do this? thanks in advance

i have data in the below format <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 4.65pt; WIDTH: 407.95pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellSpacing=0 cellPadding=0 width=544 border=0><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0...

I am trying to add a zero to the end of a series of numbers. I have a list of 20,000 customer numbers, some with 5 digits and some with 6 digits. Example some are 123456 and some are 12345. I need to make them all 6 digits long, so I decided to add a leading zero to them. I made a custom format...

i have this tab delimited text file. it has a little over 1,000,000 [one million] records. when i import this into access, it converts the "uniqueid" to a scientific number (i.e. 1.0025E+11). if i convert it to number, i lose some data. how do i convert this to a non-scientific number? thank you...

I created an exel document with a line graph. The user will enter data in the top data area which will populate the data in the below cells and automatically update the graph. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> When I use the...

I have a spreadsheet of 138 phone #'s (including area codes). About 10 of the #'s have a letter in them (i.e. 734-R42-7422) (and no, I can't just change the R to "7" - that would be too easy):rolleyes: Obviously, since they have both text and numerical characters, they won't format properly...