format cell

  1. tlc53

    Bank Account Format - Data Validation

    Hi there, I'm trying to set the format of the cell to format numbers into the following; 00-0000-0000000-000 So when 16 numbers are entered (no hyphens), it automatically comes out looking like this, for eg. 12-1234-1234567-123 But if only 15 numbers are entered, the third to last number...
  2. P

    Copy formats from an indirect cell

    I managed to copy cell formats <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...
  3. K

    Cell Format # filler is displayed

    Whatever cell format I choose, the # filler characters are always displayed. E.g.: For a selected display '$'#,##0.00, we see $#,##1.36 rather than $1.36. What is wrong ?
  4. S

    formula keeps changing

    =INDEX(Enumbers!C2:C60,MATCH('final data'!B2,Enumbers!B2:B60,0)) Question: the above formula is giving me some issues. i have a work around but it is long. the formula is correct BUT i need to move it to several cells and the formatting of the formula must remain the same. Enumbers!C2:C60...
  5. I

    leading zeros with both numbers and letters in string

    I need to add leading zeros before two separate strings for all in column E. For example: <colgroup><col width="111"></colgroup><tbody> 0336565-CM </tbody> <colgroup><col></colgroup><tbody> 336700 </tbody>
  6. A

    Help me separate a number and a formatted text into two columns

    Greetings! I have a column in a spreadsheet with cells each custom formatted to display a number (indicating quantity) and a unit of measure (such as lb., kg, can, pc, etc.). I need to separate this column into two formatted as number and text displaying the numeric value for the quantity and...
  7. D

    paragraphs

    Does anyone know if it is possible to adjust a paragraph to 1.5 line spacing in excel? specifically I have a concatenation formula mixing word and text in a merged cell box and now would like to format it appropriately. Many thanks in advance!
  8. P

    Cells Time formatting

    Hi, I have a pb with the cells formatting for a time: In a cell let's say A1, i would put a time, for ex: 08:00 and I would like to retrieve this value for the use of an Application.OnTime function However excel considers my 08:00 as 0.3333. I tried to format my cell A1 in time category but it...
  9. V

    IF cell Contains "text" then lookup "Colour"

    Hi all, I need to format a column/set of cells where each cell has some text in it, and depending on a defined list elsewhere that text does a contains lookup to see whether to colour that cell in Green/Amber or Red. I was going to use the conditional formatting traffic lights but I dont know...
  10. G

    Excel Macro - How to make whole column always Today's date

    Hi All, Background - I have 2 Excel Files A and B I manually copy all data from File A to B exact copy. I am Reading from File B only ( dont ask why not read from A as its a process) B After I copy the data to File I Read Line by line to a Sessions Screen to do that I need to make all...
  11. R

    Custom Format Cells Formulas

    Hi, I need the following to happen column A contains numbers.... in column B, I am trying to input a formula for custom format: so that the numbers will appear as such column A: 32,458,000 ; column B will show +32MM column A: -100,000 ; column B will show -100K im currently using the...
  12. V

    Conditional Formatting

    Hello, I want to conditionally format columns based on quartiles. I am able to conditionally format single column at a time but I have more than 100 columns to format. It's time consuming to edit cell values for each column. So how I can put condition in conditional formatting which is...
  13. V

    store formatted cell into variable..

    I want to store the formatted cell into a variable and then send that value into mail as body text.. eg:- i have a sheet in which i have a row give below, i just want to save the data as per it is formatted into a variable and then want to send as body text in mail.. <tbody> Hello Sir, this...
  14. E

    Format Data Labels all at once

    Hi, wondering if anyone can help me, I have a chart which has a LOT of series...and I want to show the data labels of only the series, which aren't equal to zero. So, basically, the way around this I have is to format the data labels to "#" (which sets zero to blank). However, I can only...
  15. A

    Decimals auto added to formatted cells..??

    I am having a problem where Excel 2013 is automatically adding 2 decimal places to cells that I have formatted to NOT show decimals. The decimals show up whenever I type a formula using a percentage into either that cell or into a cell near it. It appears to be random when this actually...
  16. O

    Force cell entry strictly to mm/dd/yyyy

    Using Excel 2007, and I want to force entry to calls in a date column to the format mm/dd/yyyy. Currently I have the cells formatted for mm/dd/yyyy and entered data validation date range between 12/31/1999 and 12/31/2060. However some users are too lazy to look up the day case start and just...
  17. S

    Combine date and time to create a perfect dataset with 24H per day for a periode of two year

    I have a model that works nicely with a time reference every day. The problems starts when I want to take advantage of the fact that I have new data points from measurements every 15 minutes. I would very much like be able to aggregate my data at least on hour basis and not just days in order to...
  18. T

    How to format two numbers into two currency units, with a "to" between them?

    Hello. I am creating a simple inventory, and for one of the columns I would like to have a range of sorts. In theory it would look like "$30 to $50". I was wondering if there were a way I could just enter "30 50" and it would format it to two separate currency units with a "to" between them...
  19. K

    Excel Formula

    Dear all, Did any one can teach me how to set this difficult formula in excel cell ? Please refer to the image as below. Thank you.
  20. A

    Counting multiple letters in cells

    Hi, I have a large list of policy numbers with different letters held within (eg MT/1/PD/101271A, 07BV/17345057, BL/1/ /635663A, MALZ32741) all have different formats and some contain /'s. They have all been manually added so each line differs slightly. I have a list of letter prefixes i wish...

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