formats

I have a sheet with date entries which are not in particular format. Year is in column B. Date and month are in column B with different formats. In some rows in date column the full date is in dd-mm-yyyy format. I want to get a result as dd-mmm-yyyy. Since there are different formats, if I have...

I currently havedates (calendar year) that are in 6 different formats and want to convert allthe different formats into quarters, within one formula <tbody> Format Example Expected output (Quarter) Notes DD/MM/YYYY 12/01/2017 4Q 2017 MM/YYYY 12/2017 4Q 2017 XH...

Hi All, I'm using Excel 2007 for the first time in a while since switching jobs, I hide columns and try and copy what I can see but it's copying the whole line into the new spreadsheet. Annoyingly it doesn't do it on my colleagues spreadsheets only mine?! I've tried saving as different formats...

I was working when all of a sudden my entire workbook turned grey, including the headers, toolbars, etc. Everything is still functional, but I can no longer use conditional formatting because there are no colors. (I can use the buttons and functionality, just can't see any colors anywhere.) My...

Hello All, Me.Image1.Picture = LoadPicture(fPath & "/" & Me.ListBox1.Column (0 , i) & ".jpg") How do I get other formats to work in addition to the jpg files? Thanks Kelly

Hi I just want to undestand how to read these 2 numbers formats and I think that would help me to understand the reset. I have struggled to understand these 2? why # and 0, and why 0.00 (the dot). and why both # and 0 in the same format? Would appreciate any hint 1) #,##0.00 2) #,##0

Hello, Is there a way I can combine the two number formats: 1. #,##0,;[Black](#,##0,) and 2. 0;-0;;@ In order to get a formatting rule that rounds numbers to the nearest thousand, including the separating comma; puts negative numbers in brackets; and hides zero values? Many...

Is it possible to apply the resulting formats of a number of conditional format rules to a cell via code? I have a process that copies out a number of sheets and these sheets rely on a value in a sheet that doesn't get copied out and therefore, when the new file is created all the conditional...

Is there a way to paste values and formats (but not formulas)?

I can have different formats for positive, negative, and zero values: +0;-0;=0. And I can have different formats up to two conditional value ranges: [<1]0.00;[<10]0.0;#,##0. Is there any way to combine the two so that I can both the +/-/= prefix and the variable number of decimal places? I...

Hi, Prior to today (WED 08/23/17) if I had a worksheet with a pivot table on it, formatted, etc, and wanted to email it out w/o the pivot functions, I could highlight the entire worksheet (click corner button to the left of A, and above 1), Ctl+C, right-click in cell A1, then Paste-Special...

I have a macro that copies the formats from a top row of data to the end of the data. I have started to highlight certain data with different background colors which I do not want to lose. Is there a way to copy formula (number formats, date formats, column alignments, fonts) but not the...

Hi all, I have a document that I need to convert large amounts of numbers that have been put into the decimal hours format (e.g. 0.25 hours). But I need to change this to a the number that can be formatted into the excel time formats (e.g. 0.25 hours = 10.2 minutes and or 0.0069444 as a...

Hi. I just need a little bit of code to set me off thinking the right way. I want to send the contents of a cell in excel, say the active cell where my cursor is, to a web page such as the Google search box. I have written basic code but never linked to external formats such as a web page. Many...

Hey, I regularly download a report which includes date formats in the following format: "mm/dd/yyyy hh:mm AM/PM" but as I'm based in the UK, Excel converts the dates it recognizes to "dd/mm/yyyy hh:mm". For example, here's an example with two dates; 11th and 19th September: As you can see...

I am trying to copy the format of one cell, highlight a range of cells and select visible cells only, and paste the format to those cells. The code is below. The last two lines is what is causing it to error. HELP Selection.Copy ActiveSheet.Range("$A$1:$LR$513").AutoFilter Field:=5...

I am copying a Pivot table from one workbook to another. The Paste values & columns widths works fine but the paste formats only works properly (colours, text etc.) when the Pivot is not filtered, but if any filters are applied in Pivot only some of the text formatting is pasted into new sheet...

Hello! I'm using the following to copy values from one sheet to another: Sub Copycopy() Range("B3").Copy Sheets("Sheet2").Range("B" & Rows.Count).End(xlUp).Offset(1, 0) Range("B4").Copy Sheets("Sheet2").Range("B" & Columns.Count).End(xlUp).Offset(0, 1) Range("B5").Copy...

I am using the following code to take the content from a userform and place it in certain cells in a spreadsheet ActiveCell.Value = FrmSale.TextBox2 Selection.NumberFormat = "d/m/yyyy" ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmSale.TextBox3 The problem I am having is...

Can I set the default format for phone number? I know the Format Cells feature of MS Excel. But I want some extensive kinda requirements. Like if user enter phone number +1 923-456-7890 then it should automatically formatted by removing extra spaces, special characters and the country code...