formatting text

  1. X

    export in text and functionality

    Good afternoon I have an extract of data that i wish to filter/search etc, however the driver is the date which is in a text format. I have tried unsuccessfully to alter the format of the date but i always seem draw a blank. The data looks something like this '01/12/2010 13:45:08' Can...
  2. Fa.Fa

    Help A Sistah Out!!! - Formatting Cell --> Day of Week

    SHORT VERSION: I have a column for date of draft depending on date of load. I want to be able to have the DRAFT date automatically filed after entering the date LONG VERSION: So I started helping out at a fuel company and I was bragging about being good at excel. I didn't know nearly as much...
  3. J

    Format texts within a cell

    As far as I know, it's possible to format the text within a cell to the user's liking. For example, if in cell A1 there is the following text: 'My name is Sam' Then the user is free to set My to red, name to blue and bold, and Sam to underlined, etc. I have a workbook. On the same sheet...
  4. M

    funny squares in excel

    I have converted a data base to excel and in a lot of the text in the address column are small boxes. I guess these are from dashes or unknown characters in the text. Is there any way to get rid of them other than doing it manually. Quentin

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top