format

  1. B

    How to convert date to Month/Year only

    Hi, can you please help me convert a date to month and year only. I have series of dates with the format (dd-mm-yyyy). I have customed the format to mm-yyyy but the day is still showing especially when I create a table and choose month. If I can just delete or remove the day, it would be...
  2. S

    text format issue

    I have list of numbers with text formatted, I added plan numbers which is not aligning with same text format how can I do ? old list is left aligned new right Old list 3304277 3304277 3304277 new 3304277 3304277 3304277
  3. M

    Cell format not getting changed as per original text

    I have exported a list of suppliers name as aliases name in MS excel 97-2003. Actually the service provider from where i am expoting the file allows to export only in excel format 97-2003. However, after opening the excel file it is found that few aliases name such as june12 has changed to...
  4. D

    Numbers

    Hi, I have a list of numbers that I have been inputting into a column. The problem I have been encountering is due to the different numbers being entered into each cell. I have data with numbers from 6 to 14 characters long. I have tried to format the cells with; general, numbers and custom each...
  5. S

    Conditional Format - Highlight only blank cells in row if empty (Not entire row)

    In conditional format, if I want to highlight any cell in a row that is blank , IF Column A states "Rejected" (Cells go from A: BG ) how do i do this please?
  6. B

    Exlude Pivot Table Sub-Total From Conditional Format

    Is there a way to conditional format a column in a pivot table but not include the subtotal cell? I am thinking I would test for the word 'Total' in column A and if it is found then don't perform the formatting. I am not sure how to test for 2 conditions in the formula so any help is greatly...
  7. B

    Conditional Format Pivot Table

    I have column 'F' that right now has the number 1 if an event has been cancelled during the month. I was hoping to find a way to use conditional formatting to change the number 1 to the word 'Yes' if it was cancelled. I was somewhat successful until I noticed that the monthly subtotal would have...
  8. C

    Basic Loop Not Working - Help!

    Hello, The following code is not working to loop through each sheet. Basically I want to add one column to every sheet and then copy paste some values from each sheet. The loop only works on the active sheet and ends up adding three columns, instead of one column to each of my three sheets...
  9. D

    Duplicating rows and entering values based on multiple column inputs (reorganizing for shopify)

    Hi All, I have large data set of product SKU's that are organized with multiple sizes of the same item per row and need to break each sized item on to its own row with the correct corresponding size. I have attached screen shots for clarification. I'm really hoping you all can provide some...
  10. J

    Slicer changing chart styles

    Howdy, I am an expert in a lot of things Excel, and this is driving me nuts! I create a chart and format it the way that I want. However, when I add a slicer, it changes the chart to a built-in style. I even save the chart as a template but that doesn't work. Is there a way around this...
  11. T

    Windows 10 Date Format Breaking Formula

    Good morning All I recently bought a new laptop. I have a excel sheet that checks for a companies name in a table then checks the date to see if the date is in the range I'm looking for eg. 2019. When I opened my table on my new computer my formulas all returned "0" instead of the values they...
  12. C

    Converting from General to Date Format - Hashtags

    Hi all I have a column of general formatted data which are dates displayed as yyyymmdd. When selecting 'Date' in the 'Format Cells' window, the sample output is hashtags and this is what appears in the cell if I press ok. I tried the 'Text to Columns' feature to convert to date but nothing...
  13. L

    VBA Code not keeping hyperlinks when pasting

    Hi all, Have some VBA code that copies data from 1 list and then pastes any entries that don't already exist. The issue that I have is that in column A the cells also has a hyperlink and some formatting. Code is below if anyone is steer my in the right direction. Cheers Sub CopyUnique()Dim...
  14. B

    Custom Format- Feet & Inch

    I was wandering if it was possible to have a cell that when you entered 240 and hit enter it would show 240 (20')? I was hoping this would be possible with the custom option in the format cells dialog. Thanks for the Help.
  15. O

    Conditional formatting

    How can i add a conditional format that will allow me to change a number of cells when a specific criteria is met, IE, If cells A2 to k2 contain data, i want the cells to change green when the word Open appears in I2, I would then want them to turn Red once i change the work to Closed. I...
  16. W

    Date formats

    Not sure where to start on this I have an external data source in excel with a list of dates, I do not believe that these dates are being recognised as dates and have used =DATE(RIGHT(B968,4),MID(B968,4,2),LEFT(B968,2)) on the cells which appear as 30/06/2019 and this gives me what I'm hoping...
  17. O

    Date format Reordering

    Hi. Please see link to the relevant file, below: https://1drv.ms/x/s!AtIvkRgReIvwgRPV4fmLEL1-gjz- I have a problem that I can’t seem to solve. I have this list of times and positions, with the times in hh:mm:ss format. However, the times have the minutes and and seconds in the wrong...
  18. B

    Simple Conditional Formats using VLOOKUP

    I can do complex spreadsheets but never seem to get the syntax right on conditional formats, especially when it includes a vlookup: Skipping straight to Manage Conditional Formats "IF" statement: 1. I need to say IF the value in A2 = (any value found in Array in Sheet2 column B) then format...
  19. D

    Cannot Converting Text to Number

    My accounting software exports a report to an excel spreadsheet but the all negative numbers export as text format, not number format. All the negative numbers are a text with negative sign at the end (eg 123.14-). The all positive numbers export as a number. I need to add up all the...
  20. S

    Find cells with value + conditional format...

    Hello, How do i find cells in any sheet in the whole book with value 0.09 and a conditional format that made the font bold? It's not normal bold apparently, because the built-in Find GUI doesn't find conditional bold.... Thanks!

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top