cell format

Hi I have been looking through various posts for an answer to this question and need some help please. At work we use spread sheets as timesheets. The first column is for a project code and is either entered as 'SC1111' for service calls or '12345-0111'.In both examples the numbers could be...

Hello everyone and happy Thursday! I have a procedure that allows me to view and make changes to data in a table. I list the current values for the item in one column and use simple formula to copy that value to another column where if there are changes that need to be made, the formula is...

I know how to do the Conditional Formatting stuff for cells, but I need to make a cell that turns red if the number is a prime number. I just need to know if there is a formula that returns true if the value is a prime number and false if it isn't. And if you guys know of an add-in for excel...

Pretty much I just need to be able to have zeroes in front of numbers without converting the number to text. And also note that the numbers that I am going to be pasting in that cell need to be able to be any size and still be able to keep the zeroes in front of them. popcornrulez

So lets say that the cell A1 has the number 900 in it. What I want to do is put a formula in B1 that checks to see if A1's character count is odd and if it is odd, then add a 0 in front of the original number from A1. Here's an example. COLUMN A COLUMN B ROW 1 900...

Hi, I've been given a spreadsheet filled with numbers that are three decimal places too far to the right (270 000 instead of 270.0). I tried using the decimal increase and decrease but it wont allow you to change the decimal place past the original number, so it can never be divided by 10 or...

Is there any kind of special formatting or something i can do to say. Example: when i type in 18mm that actually it could say STOP in the cell.:) and as always thanks for all your help. this forum is amazing

Is there a way to check to see if the individual characters in a cell have different formats? If I have a cell that is formated as abcd, can I at least find out that there are multiple colors? And is there any way to transfer this multi-colored format to other cells? Thanks!

Im programming an Account Manager's Report in Excel. So here's the scenario, I need to make a formula using conditional formatting on an excel document. And no macro or vb isnt an option.:confused: The user just wants it in plain conditional formatting formula...the fields or should i say...

This is going to be a n00b question but it's bothering me and I can't figure it out without wasting more time. I have a cell with a UPC code, ex- 781052055704 I want to take another UPC code of the same length and put it in the same cell, separated by a comma. This is what I want...

I've inherited a large timesheet in which hours greater than 99 need to be displayed. when i tried changing the cell format from hh:mm to d\d hh:mm and entered 7:15 in, the displayed results would read 1d 7:15. rather than the correct answer of 0d 7:15. I found that by turning the 1904 date...

I'm looking for a way to insert four numbers (e.g. 1830, 0830, 1215) into two cells (start /end time) without inserting a colon between the first two numbers and the second (e.g. 18:30, 08:30, 12:15) and ultimately compute the difference between the two times for the number of hours worked in a...

I'm developing a configuration tool for international use. I want the user to select the curreny in one central place, whereafter all fields will be formatted using the proper currency indicator ($ or USD, £ or GBP, DKK or kr. as examples). I would prefer using Excel standard currency formater...

Hi Everyone, I need help with a conditional formatting issue. I basically what excel to look at my column A and every time the data changes I want it to highlight the cells a different color. Pretty much similar to the Subtotals function but I need cell color differation not numeric...

I currently have a File with 3 Data Pages ranging from 5K to 18K lines of Data. Off of these I have 8 pages of pivot tables and charts with 4-9 Charts per page. Problem is that the file changes it' formats to Date. When I go through and change everything except Date columns to general the Pivot...

Excel 2007 Sheet and workbook are not protected. I was able to enter them earlier today. Now the option to add a comment is just not available in any cell.

Hi I have an excel form/file which I open from an Excel Macro. The excel macro does some formatting etc to the form/file while it is being opened. Everything has been running fine for over a year. However now for some unknown reason, there is some huge waiting time on some cells when I try to...

I need to use a custom number format (Excel 2003) that adds the "+" sign (w/o the double-quotes) on positive numbers the same way Excel adds "-" sign to negative numbers. I've tried fiddling with it without luck. Any idea? Thanks,

There is probably a really easy answer to this question but I cannot seem to figure it out. I need to calculate the sum of pages faxed on a fax report at my office on an excel spreadsheet which is downloaded from our server. It appears the file is not meant to be used in excel but it downloads...

Hello. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a bit of an issue where the spreadsheet I am using has a number of different currencies with no identifying means other than the formatting of the cell. <o:p></o:p> <o:p></o:p> So...