# Creating A Custom Format For One Cell?

Apr 14, 2013

I want to create a custom format for a cell for entering in "cup measurements". I want to be able to type in 5, 1/4, 1/16, etc. and have the word "cups" appear after the number in that cell. I formatted the cell to say the word cups after typing in the numbers in my cell using the code "cups".

ex: 0 "cups" works fine for whole number

so then if i change it to 0/0 "cups" is works great for only 1/8 but not 1/16 or whole numbers. Then I looked at other custom codes that already existed in my formatts so I attempted to try this code which I just kinda came up with

_(0/00);_(0);_(0/0); "cups"

well it isn't doing what I want and If I use the 0/00 "cups code and I type in 4 cups the cell then says 4/01 cups.

What does my code need to be for me to show whole numbers and and size fraction without having it look weird?

## Creating Custom Data Bar Format

Feb 11, 2014

I'm looking at what appears to be a custom chart. It is a box divided into 4 equal quadrants. In each quadrant is a percentage with the total equaling 100%. In each of the quadrants there is fill equal to the percent that is numerically written in that quadrant. I'll post a picture with this, but if I was talking cells then....

A1 = 15% B1 = 66%
A2 = 4% B2 = 15%

The backround image behind the number is filled up by volume equal to the percentage indicated. They are also color coded with red representing the highest percentage quadrant filled.

To top that, there are little arrows along the sides of each quadrant indicating an average score.

My first question is WHAT TYPE OF CHART IS THIS THING!, and second can this be done in excel?

## Format Date In Cell To Custom Format?

Feb 21, 2014

I have a column in excel which gets populated in the format "2/1/1980" when copied from a different source. I want a macro to run on this column and convert this in the below format. Required format: '02-01-80 (note the ' symbol before 02 which will keep it as text)

Existing ----> Required
2/1/1980 --> '02-01-80
2/1/1970 --> '02-01-70
2/1/1983 --> '02-01-83

I need this macro to run on two columns and replace them with the required format. I can do a find and replace either in the sheet or through hard coding the VBA, but as the date format keeps growing, I would need to do this via code and hence requesting the same.

## Custom Cell Format

Aug 30, 2009

I'm working on a workshet where ppl fill in vehicle numbers, but they all find their own unique ways to fill them up. Some of the examples are below:

MH 04TN 2315
HR 38G 9605
9605G
H9425
TN04A8451
GJ04 GA5142
KA 0072

3,4,7 are incomplete nos. while 1,2,5,6 are all complete nos. I want the format of these above nos. to look like this:

2315TN/MH04
9605G/HR38
9605G
9425H
8451A/TN04
5142GA/GJ04
0072KA

Can this be done automatically in a worksheet using the custom cell format function??.... because then it wud get formatted as necessary whenever someone enters a vehicle no. in that particular column.

## Custom Format A Cell?

Feb 8, 2013

custom formatting a cell for accommodate a Canadian postal code. The postal code looks like this

v9s 2k5. 7 charactors l#l #l#. I would like to quickly enter the data and have excel capitalize the letters and add the space for me.

## Number Custom Format A Cell

May 31, 2009

is it possible to custom format a cell in order to:

a) Present 3.33333 as 3.33 (max. of 2 decimal digits or less)
b) Present 3.333 as 3.33
c) Present 3.33 as 3.33
d) Present 3.3 as 3.3
e) Present 3 as 3 (NO zeros and NO decimal dot)

## Custom Cell Format For Alphanumerical Values

Jul 16, 2014

In Excel I have a field which requires as 14-char alphanumerical value such as AB1D520DGFSF12

I would like Excel to format it as

AB1D5.20DG.FS.F12

How can I achieve this?

## Convert Cell Format From Custom H:mm To Minutes

May 22, 2013

Data in a cell is formatted in h:mm which is truly a result of a calculation of # of hours & minutes detained at a location. D

Data is result of microstrategy query so result is

E.g. 17:08

Cell is formatted as custom h:mm, but there is actually a fictitious date of 1/1/1900 defaulting in front of h:mm when double clicking into cell or viewing in fx field above. How do I get rid of that date which is inhibiting me from converting 17:08 to minutes by using the formula of =TEXT(L3,"[m]")

## Custom Format To Align Text In A Cell

Aug 21, 2013

Are there any custom formats i could use to center align a particular text in a cell if it is chosen in a dropdown validation (example: N/A)?

I would like "N/A" to be aligned in the center and all other choices aligned to the left.

## Custom Format In Cell From Userform Textbox

Nov 11, 2009

On the attached example, there is a user form with a text box and an enter button.

What i want, is when i press the enter button, the value in the text box goes into cell B2 on sheet1 in the format of "?/???".

## Excel 2010 :: Custom Cell Format

May 5, 2014

In cell 'I6' if I enter the text "Balance" I would like it to display as "Actual" but if any other text is entered I would like it to display the text entered. How to do this using custom cell formatting. (Currently on Excel 2010).

## Change Cell Format From Custom To General Or Text And Keep Cell Value

Aug 22, 2013

Is it possible to change cell format from custom to general or text and keep the cell value

I have this in formula bar: 16/08/2013 4:37:00 AM
which is displayed in the cell as: 16/08/2013 4:37

I want to change the cell format to general but display the same information.

## Custom Cell Format In Which Space Follows Thousands Place

Feb 10, 2010

I am trying to write a custom cell format that would allow me to replace the comma with a space after the thousand's place. Therefore, 1 million would look like: 1 000 000 instead of 1,000,000. I do NOT want to change my regional settings to accomplish this.

When I write ### ### ### it accomplishes this, however, there is one small glitch. When you apply an "underline" you get the following result:

_1
_10
_100
_1 000
_10 000
_100 000
1 000 000
10 000 000
100 000 000

The underline does not lineup evenly with the "ones" digit until we reach 1 million. I want to write a universal format in which the underline lines up evenly regardless of the number.

## Recalculate Custom Function With Cell Format Change

Oct 2, 2007

I saw there were codes to sum or count cells that have a specified Fill Color
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

However it says the changing of a cells fill color will not cause the Custom Function to recalculate, I really need to recalculate the data if there are any changes in the selected range

## Custom Cell Format - Number Ending With Text String

Jun 13, 2013

How to modify a custom cell format to make data entry easier.

My goal is to have the output look like this: 'A12B-C20D: SET 10: Text string here'

Inputs needed are:

1-3 digit number between A & B
1-3 digit number between C & D
1-2 digit number after SET
Text string of variable length

Where I am stuck. So far I can get "A12B-C20D: SET 10:" to show up properly when 122010 is input. The custom format I am using looks like this: "A"##"B-C"##"D: SET "##": "

When I try to incorporate the "@" symbol the first part of the formatting goes away and the output shows up as "122010 Text string here".

I have tried:
"A"###"B-C"###"D: SET "##":";;-;_@
"A"###"B-C"###"D: SET "##": ";;@
"A"###"B-C"###"D: SET "##":";_@
"A"###"B-C"###"D: SET "##": ";;;@

## Creating A Custom Sorting

Jan 11, 2010

I am trying to create a custom sorting in VB. My sorting needs to be first on column B, then C and last on G. My data does not have headers.

## Creating Custom Dropdown In Toolbar

Jun 6, 2007

I work with excel docs that have alot of sheets. I managed to create a vba form that has a listbox populated with the sheet names, that when clicked goes to the respective sheet. The problem is that when the form is open i cannot focus on the excel sheet - the form needs to be closed first.

1 ) Is it possible to make an excel vba form dockable (so it could be displayed on the right where help would be)

Or

2) Would it be possible to create a drop down in the toolbar that would have the sheet names.

I think the latter is a cleaner solution (if possible).

## Creating New Workbook Then Giving It A Custom Filename?

May 25, 2012

I am building a macro and am just not figuring out how to do this. I am trying to create a new workbook, then give it a name. Simple right? Well, I have the format for the file name to be "mm-dd-yy Transmittal #.xlsx" but I can't figure out how to make the # part of that equation start as 1 but if the file already exists change it to 2, if that exists, change it to 3, and so on. Here's what I have so far:

Code:
Sub Transmittal()
Dim NewBook As Workbook
Dim MyPath As String

[Code]....

I don't think I'm allowed to do "x + 1" so that is probably where my problem is coming from.

## Creating Custom Tool Bar For Macros In Workbook

Jan 6, 2013

I want to create a custom tool bar for a work book but when I right click in the unused part of the tool bar area the only options I get are customize Quick access tool bar and customize the ribbon.

## Creating Custom Legend For XY Scatter Plot?

Sep 30, 2013

I need a way to make a customized legend for a scatter plot, is there any way to do that through VBA? I have a scatter plot with some points highlighted green, and some points grey depending on the user selection and need to be able to create a legend based on what the user selects (e.g. Green - Category B, Grey - Category A, etc.).

For some reason I can't get Excel to rename points on the scatter, so I feel like there is only one option: create custom images and align them correctly with labels on the plot.

Apr 16, 2006

Finally after 3 days of intensive studying VBA, my first add-in pack is ready to be installed in the office. I've got my custom form all ready, now all I need is to have excel create a custom button on the toolbar that calls up my custom form when clicked.

The idea of assigning a shortcut key doesn't really appeal to me. I'll be packaging it up in .xla format. Would be greatful if anyone can direct me on how to add a button to call up my form (only one form in fact).

## Duplicate Custom Menu Buttons When Creating Them

May 29, 2007

I have a workbook that creates three temporary menu buttons when I open it. These work fine until I try and open more then 1 workbook at a time. This creates duplicate menu buttons (3 times the number of workbooks that I open).

I call up the procedure when each workbook is opened using this code in the "ThisWorkbook" code area: ....

## Creating Custom Pivot Table Report Filter

Aug 8, 2012

I was wondering if it is possible to create a custom pivot table report filter? I would like to take an existing pivot table report filter and manually add values into it. I would like to do this because I have multiple pivot tables, some with the same values and some with different values and I have a VBA code from Contextures that applies a mass filter to all fields with the same name. So if i could manually add values into one report filter, I could filter from one location and have all my pivot tables update at the same time if they contain the value that i would like to filter by.

## How Do I Custom Format ###.####.##

Mar 2, 2009

I have a 9 digit number that I want to format as 999.9999.99 Can anyone tall me how? Does anyone know a good link with pointers on custom formats?

## Custom Number Format..?

Apr 22, 2009

If I have the following info:

A1 = 5
A2 = -4
A3 = 0

How can I use Format Cells > Custom to have them display as:

A1 = 5 up
A2 = 4 dn
A3 = Level

I've been trying and trying but keep getting a message that I should use one of Excel's pre-defined formats.

## Find When Using Custom Format

Mar 6, 2014

I have a sheet which uses a 'Custom Format' in column A, '00000' to give each row a unique reference. Is there any way to do a 'Find' using this format, e.g. 00012, rather than just 12. Searching using '00012' doesn't find the appropriate cell, whereas using '12' does?

## Custom Number Format?

Mar 25, 2014

Looking for a custom number format which will show numbers as follows:

0 = -

1234.89 = 1,235

-1234.43 = (1,234)

## Date Custom Format

Nov 22, 2006

How do you make custom date format to a cell in such a way that it appears e.g. "Jan-06"?

I tried custom format "Mmm-yy" but it still resulted to "jan-06".

I want the "J" here to be in the upper case.

## Leading Zero(s) / Custom Format? ()

Aug 23, 2007

I'm having trouble with the leading zeros of my ISBN#s; excel keeps chopping them off. I found a topic that discussed this issue, but it won't work for me.

http://www.mrexcel.com/board2/viewtopic.php?t=75303

I can't format them as text because I'm getting them as an isbn with dashes (ie:978-05689-256-7) and when I remove the dashes (even if its formatted as text) excel changes the number to 9780568.9E+12 (or something like that)

I think the solution would be to create a custom format (ie. 0000000000) to preserve the zeros, but I'm having 2 problems:

1. Since the ISBN#'s have 2 different formats (ISBN-10 & ISBN-13) I need to somehow check if the first 3 numbers are 978 then based on that it should be formatted either as ISBN-10 (0000000000) or ISBN-13 (0000000000000)

2. In the post that I linked to above it said that I won't be able to do a vlookup if its custom formatted. Is there any way around this?

## Custom Number Format ...

Jan 16, 2008

This workbook has 23 sheets for which this format will apply.

Under 1 man-hour .###
Over 1 man-hour #.##
Over 10 man-hour ##.#
Over 100 man-hour ###
Over 1000 man-hour #,###