custom format

Explain any options for the statement: FormatConditions(1).StopIfTrue = False The code works as intended. I just don't understand the values. Just wish to understand why it is always a (1) and = False in the examples. Also, want to know if there are any additional opportunities to have other...

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...

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?

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...

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...

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...

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...

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

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

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

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...

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...

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

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...

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

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 ->...

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

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 -...

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...

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.