custom format

  1. L

    Custom code to output cell range as string...

    I have come across this wonderful piece of code that kind of accomplishes what I am after, to a point. Though I would like the output string to be displayed with a few extra characters. Function Concat(rng As Range, Optional sep As String = " , ") As String Dim rngCell As Range Dim...
  2. N

    How do I force a comma between two 4 digit numbers?

    I want to put a comma between two numbers in a cell without a space, for example: 3055,2666 I tried using the custom cell format to force the separation but it didn't work. The comma keeps on separating the numbers into 30,255,666 Any ideas?
  3. M

    custom format - extract text value for conditional processing

    Hi - is there anyway to interrogate the value of text in a cell that is custom formatted? I have a spreadsheet where cells in a column are formatted as: #,##0.00" USD";-#,##0.00" USD";#,##0.00;@ #,##0.00" PHP";-#,##0.00" PHP";#,##0.00;@ #,##0.00" MXN";-#,##0.00" MXN";#,##0.00;@ ETC. I would...
  4. V

    How to read value from a cell with custom format mask

    HI, I am facing below issue. Please help me. ( using Excel 2010) I have 2 excel sheets. 1. In first excel sheet user enters any number and it has custom format mask of '000000000000000'. This format mask is not fixed. It varies from cell to cell. Ex : if user enters 1234567890 then it will...
  5. V

    Custom formatting code - rounding problem

    Here the problem raises with rounding the two decimal values. But i need like using trunc in custom formatting. I need the values not to get rounded with decimal but display as it was. Problem 1 [>=1000000]$#0.00,, "M";[>=100000]$#0.00, "K";$#.00 this code converts millions and K with 2...
  6. R

    DTPicker Custom Format in Excel 2010

    We have an Excel spreadsheet that was originally developed in Excel 2003. Subsequently, it has been used with Excel 2007 and 2010, where several differences have been discovered. The latest issue we are working on is an issue with the use of the DTPicker control. This issue is with a control...
  7. M

    Help with "simple" Custom Format !

    i have a numeric value 310.95 and want to "zero fill / right justify" into a 10-digit column i have tried to use a custom format of 0000000000 (10 0's) but that seems to "round up" to 0000000311 What format would keep the digits but remove the "." period? Thanks for any reply Mike
  8. A

    Custom Format-- date question

    I need to take 9/10/1995 and custom format to appear as S101995 I can't figure out how to on my custom formatting. Anyone? Thanks... Anita
  9. R

    Enter time in m:ss.00 format with no colons

    Hi, I have a sheet where i enter lots of times in the format m:ss.00. I would like to be able to enter these times without the punctuation, i.e. mss00 but still display in format m:ss.00. I'm guessing there is a vba way of doing this (fingers crossed). Any help would be appreciated Thanks, Ross
  10. A

    Customer Currency

    I am facing issues with formatting the currency. Currently the cell has this format $ (3,402,000) - _($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_) Need it to look like $ -3,402,000 I tried the format $* ?,_(###,###,###,##0_);?$* ?,_("-"###,###,###,##0_) however in this currency symbol...
  11. E

    Sum formula only works if placed directly below values??

    Here are my steps: 1: Open a sheet and highlight a cell 2: Open the Format box and enter this: [$-10409]$- , click OK 3: Enter 0 in that cell, note that the format takes effect and $- is displayed 4: Right below that cell enter 1 and format it as a Number 5: Highlight the cell right below that...
  12. srizki

    Custom Format

    I am trying to custom format SPD#####, and it gives me an error message, but if I format PW#####, it works. Why is that? Thanks
  13. E

    Listing words in excel using VBA program

    I need to make 2 lists: 1) With a list of 25 random people, i need to make each one a random male or female (designated by M or F). So in A2:A26 I have the numbers 1-25 designating a person but in B2:B26 I need a function that when the macro is run, it will randomly generate M and F for each...
  14. T

    Show IP addresses with leading zeros

    Does anyone know how I can format a cell to always add zeros to IP addresses? ex. change 69.21.13.222 to 069.021.013.222 The cells data is being populated from other spreadsheets using a VLOOKUP. I just need the leading zeros. Thanks
  15. J

    Japanese currency custom format

    Hi, I would like to set the format of a cell to the Japanese currency format. This means that the comma separator occurs at 4-digit interval instead of 3 (ten-thousand separator instead of thousand separator) like this: 1,000 -> 1000 10,000 -> 1,0000 1,000,000 ->100,0000 1,000,000,000 ->...
  16. D

    SSN and phone numbers not formatting

    I have columns of ssn and ph numbers that are not responding to special or custom formatting. Any ideas why? I am using 2007 and the file sent to me is Excel 2003 if that makes a difference. I am very new to Excel and can use all the help I can get. Thanks
  17. V

    Help needed for Custom Gantt-like formatting

    Hello, I'm in the process of creating a custom gantt formulation for a specific batch production case, without using excel charts. This uses some basic operations research methodology, but the problem is the the code, not in method. The production case is like this: I have 4 processes -...
  18. L

    custom date format to uppercase months?

    I'd like to be able to take an already-existing date like 3/14/09 and create a custom format to make it MARCH '09. "mmmm 'yy" <mmmm yy=""> results in March '09, but </mmmm>"MMMM 'yy" yields the same result. Is there any way to create an all-cap custom cell format, or do I need a macro/VB to...
  19. T

    Change cell format

    Very simple question. If I wanted to change an existing cell "Down 0.32 (19.63%)" And I want to change it to "19.63" How would I go about doing it? **I want to be able to fill this formaula down a column, and all of the cells will be ending in "%)" Thank you.
  20. M

    newbie - custom format help

    I have a spreadsheet that has a column that has a date such as 0510; which represents YR MO. I would like this column to display as follows: 2005 October.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top