format cell

Dear all, Did any one can teach me how to set this difficult formula in excel cell ? Please refer to the image as below. Thank you.

Hi, I have a large list of policy numbers with different letters held within (eg MT/1/PD/101271A, 07BV/17345057, BL/1/ /635663A, MALZ32741) all have different formats and some contain /'s. They have all been manually added so each line differs slightly. I have a list of letter prefixes i wish...

hi, i would like to be able to input a time as ss00 (without any colons, commas or fullstops) and then require the time entered to be formatted and displayed as ss.00. also, occassionally the times may be just over 1 min so would be something like 1:01.34, i would like to be able to put this...

Hello,Hello, I am trying to write code that will allow only certain formats in a cell: E.g. Case [A1] If 0 < Len(Target.Value) And (Len(Target.Value) > 2 Or IsNumeric(Target.Value) = False) Then MsgBox "Value entered must be a 1 or 2 digits long number."...

Hi, normalny in the column "M" I have data format (ex. 25.05.2013 12:10:55), but sometime the values are difrent: -628022.9725 or -623275.021412037 Now I want to remove all the values wrong values. I have something like: With sourceWb.Sheets(1) LastRow =...

Hi and thanks in advance. Got this code from another forum and it doesnt work. It changes sheets but nothing happens. I would like to Find and Replace a fill colour using RGB, in ALL cells in ALL sheets in ALL open workbooks, regardless of any other formats on the cell. [Sub ChangeFormats()...

Hi Everyone, I have a situation where i have to copy data from web page and paste the data in a single excel cell without losing formatting. Data on a web page will be like the below: **************************************** This is in bold This is in red color and bold...

Hi, I am trying to pass barcode data from excel to a text file and then back into excel. The barcodes are 8 or 12 character long and they can have or not have preceding zeros. I know of several ways to retain preceding zeros such as adding apostrophes before data or using custom formatting, but...

I need each cell in Range E18:BL18 to change color based on the letter in the cell. This is what I was thinking but it's not working: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Select Case Range("E18:BL18").Value Case Is = "M" Cell.Interior.Color = vbBlue...

Hello, I'm having a problem with an Auto Filtered Column trying to select Week Ending Dates which are Formatted in text as yyyymmdd. I want the sub procedure to have user select only a Start Date and an End Date for a monthly period. I can get the inbox to perfom with both periods, but when...

Hello and thank you for helping me on my question. I have this line of code to format some values. ActiveSheet.Columns("F:I").NumberFormat = "$#,###,###.00" The output of this code is producing a result like this: -$8.00 I would like to get a result that looked like this: $ -8.00 or $...

Hello, I have a question about separating a text column by commas. So If my column has 12 characters I would like to know how to add a comma every 4 characters. Regardless of how many characters that there is?

Hello everyone, I need some help referencing columns in a range. Below is a sample of the code. In the code, the first column of the range is given a numerical format and some color; likewise, the last column is given a different color and format. My goal is to target the cells in the middle...

Is there any way to use the Excel Worksheet IF function and keep the format of a cell? =IF(RawData!E34="","",RawData!E34) It does what I want but sometimes, the reference cell is filled with a blue color. Any ideas?

I hope someone can help the cells on the left are green amber and green if they r they green the cell on the right will auto put a 2 in the cell if its amber it puts a 1 and red a 0. Thank you

Hi I want to format a cell to show value to the nearest half number in decimal. I do not want to use the ROUND formula or VBA because this is to be distributed for manual entry to non-proficient users (non-sentient in some cases!). Equally, I cannot rely on macros being enabled, or permitted...

Hi, I don't know if it's possible but I would like to format cells in order to have only the first letter displayed. For instance, if I enter "AMERICAN" in a cell, I would like to see only "A" but to keep the "AMERICAN" value. Thanks a lot.

Hey There, I am experiencing an issue within an Excel workbook dealing with hyper links. I have created a navigation tab with links to all the other tabs within the workbook. I added "Home" links in the top left corner of every tab that links back to the main "Nav" tab. Every time I open the...

I've got two issues. 1) I want to export data to Excel 2007/2010 using copyRecordset method. It works fine for non filtered recordset,but for a filtered recordset it just ignores the filter and dumps all the record on to the excel sheet. I've not been able to find a solution to that on the net...

I have a lookup formula that is returning values to include in a part number. The value that comes up might be "2103" or "5242698" but I need them all to be formatted with 8 digits so I want the appropriate amnt. of 0s to be added. i.e. Formula Value / Required Format 2103 =...