format

  1. T

    Crazy Date Formatting????

    Hi, I'm having some issues with date formats from a workbook downloaded from a Govt/County site. The date as downloaded shows as two different date formats inside one column: 03/17/2016 02:22:00 PM - formatted as General, and 2/09/16 13:29 - formatted as Custom (d/mm/yy h:mm) The issue is...
  2. R

    Cell Format Include a Footnote

    Hi team, I was wondering if there was a way to format a cell in excel so that it has a footnote. The objective is to mantain the value of the cell dynamic (i'ts being picked up with a formula). Any ideas? For example it would be A1 5 A2 3 A3 =A1+A2 Display 81 Thank you Daniel
  3. T

    VBA Macro format specific tables in Word

    Hi all, I'm struggling with a macro for automatic formatting tables in a Word document. The macro below, while flawed did work when only tables of a certain format where in the Word file. Now other tables have been added and that breaks down the macro. The macro should only format specific...
  4. Nelson78

    Copy and Paste same format

    Hello everybody. I've filtered some records on the original workbook and I've pasted them in a new workbook. If .SpecialCells(xlCellTypeVisible).Count > 2 Then .Offset(1, 0).Resize(lr - 1).SpecialCells(xlCellTypeVisible).EntireRow.Copy new.Sheets(1).Range("A2") End...
  5. Y

    Format number digit

    I Use zeros to format the number of digits i want when generating numbers, i.e 000 will display 054, 001, etc. how do i code it on a userform to just type the number of digits i want directly instead of using zeros, i.e typing 5 in a textbox and it will generate numbers like 00045,00004,00569, etc?
  6. B

    Text to columns time format gets AM/PM wrong

    <tbody> Column A Column B 08/07/2019 12:00 AM 01/00/1900 7:03 AM </tbody> I am doing a text to columns where I have a date and time in Column A - and I want it to have the date in column A and the time in column B Here is what the original looks like 08/07/2019 7:03 PM The table above...
  7. D

    Rearranging data

    Hi guys!!!! I have this data of weight meassurements, i have one measurement for every hour of the last 5 years, but the format of the table its not useful for me, I need to change it to another format. The one in green is the one i have, the one in yellow is the one I need. <tbody> I used...
  8. M

    date conversion

    Excel 2007 Column A contains dates in dd-mm-yy format. How to convert the dates into dd-mm-yyyy format? Example: 28-02-09 to 28-02-2009 Thanks
  9. K

    How To Keep Pivot Table Format

    Is there a way to keep the formatting, i.e. margins, headers/footers, layout, etc., of the initial Pivot Table and have it carry over to all of the others once I use the 'Show Report Filter Pages'? I have the original one formatted exactly how I want it, but when I have each of the others...
  10. S

    CDate

    Greetings, I have a I column of values of the format " Aug 30, 2018" and so on. I would like to be able to convert these into the format "MM/DD/YYYY" Dim A as Long, LastRow as Long LastRow = Cells(Rows.Count,"A").End(xlUp).Row For K = LastRow to 1 Step -1 CDate(Cells(K,"A").value) =...
  11. I

    Recorded macro placed in code shows not supported

    Hi, I have the following working code in use. Private Sub Worksheet_Activate() Range("A3") = UCase(Format(Now, "mmmm")) Range("D3") = Year(Now) Range("A1:E3").HorizontalAlignment = xlCenter Range("A1:E3").VerticalAlignment = xlCenter Range("A1:E30, D31:E31, B35:C37, E35:E37...
  12. B

    Date format showing two time zones?

    I use the following Date Format[$-en-US]dddd, mmmm d, yyyy h:mm AM/PM;@ which, when I enter : “5/10 13:00” reformats to “Friday, May 10, 2019, 1:00 pm.” Is there any way I could get it to show this in two time zones, such as “Friday, May 10, 2019, 1:00 pm. EDT / 10:00 am. PDT”? Thanks -- Blackie
  13. F

    Format part of cell with underline

    Is it possible to format half of a cell with a different format? I'm using =TEXT(G5,"0.00")&CHAR(10)&TEXT(E5,"0.00") and would like to format the first half with an underline so it looks like a division. Like this 1267.98 66.21
  14. M

    sumproduct help

    Excel 2007 Formula in S3: =SUMPRODUCT(-- (D3:D20,D23:D47,D51:D67,D70:D74,D77:D124,D129:D140,D143: D153,D156:D157=R3),P3:P20,P23:P47,P51:P67,P70:P74,P77:P12 4,P129:P140,P143:P153,P156:P157) Column D contains Amount in numericals. Column R3 is a Helper Cell containing name like KM in general...
  15. G

    Format cell to delete a portion of a cell text

    Hi, I am using a software program to export my data into excel, then using a macro to organize the data. Unfortunately, the software program only has the option to have both date AND time exported so the cells containing that data look like the following: 8/29/2019 4:00 PM This occurs in...
  16. T

    How to create a hyperlink on a blank cell in excel

    Is it possible to format a blank cell in excel as a hyperlink for a web page. I need to do a blank cell because the website address will always be different depending upon the account. I want to format cell K3 that is blank as a hyperlink
  17. M

    Converting 0100-0200 into 01:00-02:00 though VBA/Formulas

    Good Evening, I have two queries: Firstly, I have a excel spreadsheet where it imports the booking data from the word form. Owing to the word form timing format, the timing in excel appear as 0100-0200 whereas I would like them to appear as 01:00-02:00. Is that possible through coding or...
  18. T

    Format cell with currency informed in other cell using a single formula

    HI, I cell B1 I have a drop down list to select the currencies that are written in the ISO currency code (EUR, USD,....) cell C1 I have the qty Cell D1 the unit value Cell E1 is C1*D1 I am looking for a formula to format the cell E1 as currency using the currency informed in B1 I have...
  19. S

    conditional format to change alignment in a cell if a number is entered

    Hi Column B is formatted to align left. Sometimes i enter a number instead of a text. I then click on a button on the ribbon to change the ailgnment I got to wondering....... Is there a way to have conditional format change it? mike
  20. D

    Conditional formatting

    I would like a colored row on a certain date to turn from red to yellow, how would I format that?

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