formats

  1. P

    Convert date entries with different formats as dd-mmm-yyyy.

    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...
  2. A

    Converting 6 different date formats into Quarters

    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...
  3. S

    Copying and pasting Hidden columns - Excel 2007

    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...
  4. R

    Urgent Help Needed

    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...
  5. kelly mort

    Multiple Image Format On UserForm

    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
  6. L

    how to interpret this number formats

    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
  7. G

    Combining number formats

    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...
  8. M

    Apply formats as per results of cell conditional formatting

    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...
  9. K

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

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

    Combine conditional sections and conditional values in custom formats?

    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...
  11. A

    Pivot Table - Issue with Copy, paste special value over existing Pivot

    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...
  12. K

    copy cell formats, but not background color

    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...
  13. M

    Changing hour formats to useable excel time formats

    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...
  14. S

    Linking to web page

    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...
  15. K

    VBA: Converting US and UK date formats

    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...
  16. V

    Copy format of a cell to a range of other cells in VB

    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...
  17. F

    VBA Copy Pivot to new Workbook format issues

    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...
  18. P

    Copy Values, not format

    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...
  19. B

    Format from a textbox in a userform

    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...
  20. M

    set a default format for phone number

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top