1. D

    VBA help - Rollforward date within text

    Hi, I was wondering if anyone could help me as i'm a bit stuck on the following task. I need to automate the roll-forward of an excel spreadsheet where the year which is being increased by 1 is within text. ABC2019ABCDEFG will need to be roll-forwarded to ABC2020ABCDEFG. The issues I'm...
  2. M

    Formatting Dates from outside software system

    To anyone who can help, Our software system exported data to excel. However, the date formats cannot be sorted properly. I noticed that if I double click on a cell, so my cursor is showing and then press escape, the format automatically changes to a date format that works for sorting. I have...
  3. I

    Data Conversion

    Hello - thanks in advance for the help. How do I convert the following "2019-Q3" which is formatted in excel as "General" to a date format so I can run a pivot table and be able to group by the date? Thank you
  4. A

    VBA to format tange of cells based off value in another cell

    I’m looking to format a range of cells based on a value in othercells. On the “Menu” sheet I have the following table <tbody> Menu Sheet Cell Measure Number Format A119 T1.1 $ A120 T1.2 % A121...
  5. N

    Formatting a Calendar Entry using Forms VBA

    Hi. :) The date the Monthview brings back onto my sheet is not recognised as a date. So when I try to look up the date to name the tab it isn't recognised. I have tried the following Selection.NumberFormat = "DD/MM/YYYY" And Application.SendKeys "{F2}", True Application.SendKeys...
  6. S

    Format and convert hours to Minutes

    Hello I have a column A1 (Time) which has the following data and since it does not have similar formatting I am finding it difficult to convert it into minutes. Any help would be appreciated. <tbody> Time Minutes 1d 3h 42m 1662 18h 38m 1118 34m 34 7h 5m 425 </tbody> Regards...
  7. G

    Conditional Format with Search and Days

    Hello, I'm attempting to add conditional formatting to a sheet. The Conditional Format is based on: 1) Column A contains the word "Sales" AND Column C is < 30 2) Column A does not contain the word "Sales" AND Column C is < 90 I attempted to build out the formula, but it does not work as...
  8. V

    How to automatically change the visual value after changing number format?

    I wrote a macro to change format of cell by adding pre-fix "19V". The format change under the hood but the value I see only change after I go to the cell and press Enter. How to automatically change the visual value as well? Selection.NumberFormat = """19V""@" Eg: 12345 => 19V12345 (visual...
  9. avisoft20

    Conditional Format

    Dear All Expert, I am working on a data i need conditional format formula. Example: <tbody> Date Material Code 01/10/2019 2002025 01/10/2019 2002025 01/10/2019 2002115 </tbody> Condition:if material code is same on same date it will be highlighted. Thanx & Regards. Avisoft
  10. M

    Pivot Table Time Values Display As 00:00:00

    I'm working on a Frequency Distribution for time values. I have separate incidents with a start date and resolved date. I used an excel formula to retrieve the time difference between the two. I'm trying to make a pivot table with Time Elapsed but it shows up as 00:00:00. Any ideas of what's...
  11. S

    Set a shortcut key for "Copy Format"

    Hi, Is there a way to set a shortcut key for "Copy Format" ? Or use VBA to imitate the usual mouse-click / mouse-double-click function of "Copy Format" Thanks a lot!
  12. V

    Text & General Format to Data Format all the data - code/VBA required

    Hi all, we have the following data and want to convert in "date", we have tried Code 1 =TEXT(A1,"mm\/dd\/yyyy")+0 Code 2 =TEXT(G12,"mm/dd/yyyy") but problem not solved, pls check the result after using the above code and provide the code/vba, also when we copy the data...
  13. K

    time value format

    hi all, i would like to ask how can i amend my issue. A1 is used to enter a time to color B1:B100 by conditional formatting which is greater than A1 i've manual changed the format both are "hh:mm", while i always get stuck in column B with format "date time" like "8/10/2019 20:15", thus i cant...
  14. S

    Rounding while still seeing ".0"

    Good Morning, I'm trying to use a simple rounding formula but I don't want to lose the ".0" when a number, say 14.96, is rounded up to 15. I cannot format the cell itself. Ideas on how to do this. It's probably super simple but I've been brain farting all afternoon/evening....
  15. L

    text to time

    Hi I highlight cells A1:A3 and changed the format to Text. Then I entered time <tbody> 1:00 2:00 3:00 </tbody> They are all aligned to the left. So far so good. Then I highlighted them again and changed the format to Time. Nothing changed!!. What I needed to do is to double click on...
  16. N

    Retrieve Date and Time format from appended queries

    Hello, I am new with PowerBI and not sure if this is even possible. I have a main table/data model which I appended multiple months of data (different tables per month, which I append tables per month). A column on the data model had originally a Date and Time format which I changed the format...
  17. T

    IF/OR Usage to format cells based on given value in any set of columns

    Hi, I want to format the A column depending on the data in I J and K column so i could make 3 different Formatting rules =$I1="True" But what if i want to do I J and K in the same formatting rule? Sorry if its a bit unclear
  18. K

    vlookup time format

    Hi all, i have a question on time format when vlookup. how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater than 18:30(subject to change in A1) <tbody> 18:45 21:30 17:15 16:30 21:00 19:45...
  19. L

    convert time to fractions 1/24/ 2/24 etc

    Hi I want to convert time to general (number). I want the numbers to be appeared like this 1/24, 2/24, 3/24,...., 24/24 I changed times to fractions format but I did not get what I want. In some cases like 10:00 pm, the fraction format changed it to 1 instead of 22/24. Thank you very much...
  20. N

    Conditional formatting

    HI, Newbie here, have formatted a table to grey out rows based on a condition on a column, but it has overridden my rag colouring, can anyone help? I have the if = to AR then format then this is for the lines - =$R10="Yes"

Some videos you may like

This Week's Hot Topics