A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
Custom Format with different Criteria by Santhosh Mani
I need to format a complete column of cells as below. I tried format Cell Number Custom but accepts only two criteria, not all eight criteria listed...
April 21st, 2008 12:57 PM
by Santhosh Mani Go to last post
2 178
custom formating a cell by VDU
Hello, I have a problem in creating a custom format and I'm running out of time, could you please help me. I have a cell containing a series of concatenated...
November 22nd, 2006 10:00 AM
by VDU Go to last post
2 70
Custom Formating Cells by JohnWFUBMC
I want to format a cell so that when I type a number into that cell it will take the absolute value of that number and then multiple it by 1000. Is there...
December 14th, 2007 07:35 PM
by Gord Dibben Go to last post
2 102
Custom Formating Letters to Numbers while Displaying Letters by Luke Androsiglio
I am trying to accomplish this in terms of letter grades corresponding to number grades. How do I format a cell so that I can enter a letter grade: A, A-, B+,...
March 31st, 2010 06:29 PM
by Gord Dibben Go to last post
2 139
Custom formating of cells by Dale
I have a number in a cell that is in whole numbers that I needs to be reported in $,000. In the Format cells menu on the nubers tab there are several...
February 28th, 2007 10:17 PM
by Gord Dibben Go to last post
2 61
Custom formats to round numbers such as 465,123 to 465,000 by malcolmt
Rather than use the @round function which can be tedious at times I would like to know if you can use custom formats to complete the task
February 8th, 2006 01:46 AM
by Brian Go to last post
2 113
Custom Formatting by Tarfun
What is the custom format to display numbers to the nearest 100 or nearest 10, i.e., 721 be displyed as 700 or 720. I know that formattig a number that way...
August 24th, 2008 07:38 AM
by John C[_2_] Go to last post
7 92
Custom formatting by Yvonne
I have a very large spreadsheet in which I need to change all dates that appear this way: 1994 - 1995, to this: (1994 - 1995). Is there any way I can...
April 3rd, 2008 04:40 PM
by Ivyleaf Go to last post
4 129
Custom Formatting by Aaron
Hi, I have a cell that I want to have a number and a letter in, ie 0.02 g. I need to be able to set this format based on another cells current formatting...
December 9th, 2008 07:10 AM
by Aaron Go to last post
2 77
Custom Formatting by Nikki
I want to format a row to change background color if a cell in the row says PD10/ 05. But it won't always say 05- how can I make a generic for that in an...
February 13th, 2006 10:10 PM
by Gary''s Student Go to last post
2 83
custom formatting cells by lisa & corinne
we are trying to remember how to show 7 (type only the seven in the cell) as .0007, by formatting the cell. we have tried several different custom formats,...
December 9th, 2003 09:15 PM
by corinne & lisa Go to last post
2 403
Custom formatting not functioning in Excel by Seenath
I have an Excel sheet in which date related formulae were working properly. But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by Excel. Date...
January 28th, 2006 01:33 PM
by Niek Otten Go to last post
1 108
Custom Formatting: Can I set up a condition? by Phrank
Here's what I have: Column A = Start time Column B = Nominal Sample Time (i.e., 5 m, or 5 min from start time) Column C = Relative Sample Time (Actual time -...
December 13th, 2006 10:42 AM
by Martin Fishlock Go to last post
1 76
custom formatting?? by PattiTechWriter
Do you know if you can force a specific formatting for a column? What I want to do is, I have a column with a MAC Address that looks like this: 005004a1b4a9...
December 5th, 2005 11:36 PM
by PattiTechWriter Go to last post
2 217
Custom Formula in Pivot Table Row by Cam
Hello all, I use Pivot Tables (Excel 2003) to create Profit & Loss statements. I would like to insert a custom formula to calculate 1) Gross Profit and 2)...
January 28th, 2006 02:03 PM
by Gilles Desjardins Go to last post
1 102
Custom function by Christina L.
I have written a custom Excel function in VBA which retrieves data from a remote server. This function can take up to several seconds to run, depending on a...
May 10th, 2006 06:38 PM
by Brian Taylor Go to last post
1 88
Custom Function by Spencer Hutton
I have written a simple VBA function: Function SpenceTAX(Cost, Rate) SpenceTAX = Cost + (Cost * Rate) End Function it adds tax to an items cost. how do i...
April 29th, 2005 08:21 PM
by Gord Dibben Go to last post
2 114
Custom Function & Personal.XLS by
Excel 2000 SR1, Win2kPro Using a custom function works fine if the module is in my current workbook, but when I move the function to the module in my...
July 30th, 2004 07:04 AM
by Frank Kabel Go to last post
1 324
Custom Function basic by Joe_Germany
Hello all.. I am trying to make a custom function.. I am using german Excel.. My qn is - Can we use the standard functions inside vb.. For eg, ...
(Multi-page thread 1 2)
August 31st, 2006 07:05 PM
by Pete_UK Go to last post
12 131
Custom Function not being auto calculated when cells change..help? by Alex Wolff
I created a custom function (See below) Which takes validated input from 7 other cells parses using MID and concantenates and returns the result into an 8th...
March 22nd, 2005 08:06 PM
by Dave Peterson Go to last post
4 292
Post New Thread


Display Options
Showing threads 20001 to 20020 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.