formatted

Afternoon all, Is it possible to change the back ground colour on the multipages ? no default option appears ? also The caption you add to the pages, can that caption be formatted, as I wanted it to appear font size 12 and in bold ? Thanks Pauljj

Hi all I have this code: Order00a.ComboBox4.List = Range("QTIME").Value Order00a.ComboBox4.ListIndex = 0 My issue is, the values in the range are formatted as time, and when they appear in my combobox, they are decimals. How do I adjust this?

I have 2 excel files with columns of serial numbers in each file. The numbers are formatted as numbers in one file and as text with a leading ' in the other file. I need a macro to add the ' to the cells formatted as numbers in order to do a Vlookup. Thanks for your help! Trebormac

Searched the archives but I could not find an answer... I have a cell with a formatted date entry (MM/DD/YYYY). I need to use the DD to calculate an average per day where the data I am using is thru the prior date: F3 = (B3 / (DD-1)) What would be the correct way to write this? Thank you...

Good afternoon, I have developed a pretty complicated sheet for some users, but they are still having issues copying a page and pasting into the template. Basically, the sheet I have made stays static, then every week they need to update the orders sheet, and stock information. (They are...

hello! i have a sheet for recording trips, yes the same sheet i have been playing with for 17 years. P12 (formatted as text) is time (1109) Q12 (formatted as text) is time (1207) R12 (formatted as 13:30) is where i input the elapsed time. (0:58) S12 (formatted as number 0.00 )has a formula...

Hi everyone, I'm trying to troubleshoot a run-time error 91 on a macro in my workbook. Essentially this macro looks through active worksheets to find any issues (special formatted cells in active worksheets) and returns the comments in these formatted cells in a 'issue worksheet' (I hope that...

Please can someone help me with my query. How do i cut off the surplus numbers in Excel to show only 0.00 0.0000000000000000000000000001234567 I need the new value to be 0.00 not formatted as 0.00 Many thanks in advance

I have a column with unique IDs that are supposed to be 7 characters in length. Sometimes when these get manually input the leading 0 is omitted, so I was writing a macro to check, and if the number of characters is 6, to add a 0 to the beginning. In some instances these cells are formatted as...

Can the following be done with a excel formula as I am unable to get it right? I am using Excel 2007 on Windows. If cell A1 is formatted as 'General' then return the contents of cell B1 but if A1 is formatted as a 'Date' then return the contents of cell C1. I can find a lot of information...

I have created the following: ="Data as at 5pm "&TODAY() and it results with the following: Data as at 5pm 43172 Have formatted the cell to date. Doesn't work. Why is the date defaulting to its numerical value? Thanks

This gets me every time.. looking at the worksheet Cell I see 2:15 But reading Cells(row, Col) in VBA results in 0.09375. I think this is because the cell is formatted to suit a different data type. Is there a solid way to get "2:15" ? I tried CStr but no change.

Hello, I attached the workbook, https://nofile.io/f/hV3NG1FvKkS/Data+Sample.xlsx I removed most of the data just to drill down to the core issue. The Problem that I'm having is: I have 3 sheets on that workbook Main - Site 2 - Site 3 I'm trying to pull data ( prices ) from Site 2 & Site 3...

I have a cell (L3) with a value of 2,620,000 that is formatted to read 2.62. I have another cell (R3) that has a value "1280 x 1024 at 100 fps" and that is no formatting. I would like to combine the two into one cell that reads 2.62 B (1280 x 1024 at 100 fps). My first stab at it does not...

Hi everyone. I have two issues that I think a lot of you would be able to help with. Issue#1: Conditional Formatting I have 3 cells in different location in the same row that need to be conditionally formatted. Each of the three cells already have a formula in them. End state, I want the...

I am not experienced in VBA coding at all and I have a seemingly simple question. I would like to create a click button macro which will find and select every currency formated cell which includes the euro symbol € or every currency formatted cell that has a sum above 0 within a specific column...

Hi there, I know that the answer to this is staring me in the face, but I can't get my brain into gear this morning I have a range (I182:I186) which is reflecting dates from other sheets (date formatted 20180116). This range is formatted as TEXT as the reference cells are also formatted as TEXT...

Hi All; First of all, thanks a lot in advance for your time and help. Here is my question; I'm trying to use Excel's Index and Match functions within VBA code to retrieve data from another workbook, based on a criteria in a cell. The formula below works without any problem and brings me the...

On right is the pivot table output I am looking for. Each row contains the date and things are being grouped by the second column: campaign. On the left, however, is a new one I am trying to set up to mimic the one on right but is just formatted differently and I can't figure out what the...

Hi there Ive written a code that timestamp a certain cell in a table:ws2.ListObjects("Table1").DataBodyRange(i, 1).Value = Format(Now(), "dd.mm.yyyy") However, when trying to filter the dates in the table they are not recognized as dates. The whole collumn in the sheet is formatted as dates...