format cells

  1. P

    How can I Formati a column to show a reading age as YY/MM

    Hi I'm struggling to change the format of my information to show reading ages in the YY/MM range. I already have info and when I custon and change to YY/MM it changes all the years to 19 from any year age ie 10/11 = 10yrs 11 monthes. but when I custom format the cell it changes to 19/11 -...
  2. F

    Comparison of Columns VBA

    Hi All I am working on some vba and i haven't got to the point where i will need this yet but i know it will be useful. I am looking to compare 2 columns lets say A and B where they contain values (Not empty) and the length of the columns are always different. (A and B will be the same length...
  3. R

    Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped

    I'm working on a Template that will be Themed buy a few members on a monthly basis. All the Sheets are protected and the user is to basically just Background Fill the Cells, etc. All Sheets are to be Themed Identically. But to avoid doing the same thing on each Sheet, they group the sheets...
  4. S

    Format Cells: Create custom prefix that will work on both number and text

    I need to create a custom prefix that will work with cells that contain both number only and number and text data. I've used "000-0"#### but that only works with number only cells. I've also tried "000-0"@ but it only displays the text. There must be a simple solution I can't think of! Many thanks
  5. H

    Excel dates in a specific format

    I'd like to find a way to automatically be able to format dates as yyyy-mm-dd hh:mm:ss without having to keep retyping that in the Format Cells -> Number -> Custom section. Is there a) any way to automatically be able to add this as one of the options so I can simply select it or b) is there...
  6. D

    Paste link not retaining formatting within cells

    I have a workbook which is linked to a master workbook and contains formatting within cells such as bold,italic etc but only parts of the cell are formatted. I've been trying to find out how to retain this formatting when using the paste link function but so far without any joy. I've tried...
  7. B

    VBA NumberFormat General, not working for all the cells

    Hi, I would like to format a excel file to "General", but it's not working for all cells (some are custom, pourcentage...). here is my code : With ActiveSheet.Range("A1").Resize(LineIndex, 1) .Value = WorksheetFunction.Transpose(strLine) .NumberFormat = "General"...
  8. H

    Move data from blocks to vertical rows

    Hi all, I am looking to move data from this format: <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</style><![endif]--> <tbody> Trading Name: BRAD GARLICK FORD Division: [...
  9. A

    Phone number format problem in excel

    Hi Experts, I am facing a problem. Whenever i put a phone number into cells it converts to formulas and i tried finding the solutions on google and found some solution format cells etc but nothing is helped me. I have shared a pic sample below. Please help if someone knows a solution it. Also I...
  10. P

    Dynamic formatting in pivot table

    Hi everyone, I am a newbie in VBA and I need some help to format my sheet. I am trying to color the values in my pivot table, and I have some troubles to find a dynamic way to extend the new format when new lines are added to my file. What I want the macro to do is basically to color each cell...
  11. D

    Excel calculation help needed

    Hi Everyone, I am calculating a date time timestamp but come up with an answer of ######### due to it being a negative d:h:m example: 7/1/2015 1:30 PM - 7/1/2015 1:27 PM = ######## What I would like to see for an answer is the actual negative number in the d:h:m format (i.e. - 0:0:03)...
  12. B

    VBA to right align text if the first characters are " "

    I have data in column A that I would like align right if =(LEFT($A10,4)=" ") is true. Is there a way with VBA to run through all of the rows in column A and apply the align right to all the cells that are true? Thanks for your help!
  13. C

    Custom Format With Space

    User enters text into a cell such as: T2K5G1. I want the custom format to convert that to: T2K 5G1. So it's the same thing with just a space in between. I tried 000 000 in the custom format but that didn't work. Suggestions?
  14. C

    Insert Row Above Button and Format New Rows

    I am working on an excel file to help with our meeting minutes with my job. Currently every time there is a new item or minute the updater has to manually insert and format the cells. I want trying to make a macro that will work by clicking a button towards the bottom that will add 4 new...
  15. T

    Displaying Numbers with comma

    Hi guys, I am trying to format a column to display numbers as 16,00 or 1654,00 but i am unable to format the cells appropriately and can only get a result of 16.00 and 1,650.00. I need any future number entered in the column/cell to use this format so using a =TEXT(cell,"0,00") formula or...
  16. Z

    Format cells based on legend

    I have a schedule in Excel. On Sheet1 I have a legend that dictates cell colors based on value. Examples: cell value = 1, cell is grey and text is bold cell value = 1T, cell is grey cell value = 1F, cell is grey cell value = 2 cell is blue and text is bold cell value = 2T cell is blue...
  17. D

    'Too many cell formats' & 'Microsoft Excel cannot paste the data' errors, file corrupted?

    When I try to change formatting in a spreadsheet A, I get the following message: 'too many cell formats' When I try to copy data from   spreadsheet B to spreadsheet A, I get the following error: ‘Microsoft Excel cannot paste the data’. However, when I copy data from spreadsheet B into a new...
  18. R

    Strange Date Format 11/4/14, 1:09 PM will not convert to Excel Date Time due to comma placement

    A popular product has an Export to Excel with a single column for Date / Time. The format shown has the date [comma] Time. It won't convert to a Date date type due to the comma. A popular software tool takes this data off of the internet and converts it to this text string. I can manually use...
  19. B

    How to assign the format of adjacent column to the last column in excel using VBA

    Hi, I have added a new column as the last column to an existing excel using VBA. After adding a new column, though the background color and other format properties same as that of the adjacent column are applied to the column that I inserted, the grid lines it did not copy the same grid borders...
  20. H

    Format Cells 0.0% for < 1, 0% for >1

    I am trying to do simple Format of cells to have it display one digit beyond the decimal for numbers that are smaller than 1, and then no decimal for >1. So it should return: 0.2% or 0.5% and 1%, 5%, 10% [>=1]±#%;±0.0%;"" doesn't work. Suggestions?

Some videos you may like

This Week's Hot Topics

Top