Number Formatting #3
Thank you, now at least it makes sense! :)
Nan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6785
View this thread: http://www.excelforum.com/showthread.php?threadid=272052
See the thread started by M.Johnson about rounding. You might find
something of use to you there too.
"Nan" <Nan.firstname.lastname@example.org> wrote in message
> Thank you, now at least it makes sense! :)
&...nunber format in Excel 2000
I am looking for a way by using the "format cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's and not leading
zero's. All I can do is get leading zero's.
"Erle" <email@example.com> wrote in message
> I am looking for a way by using the "format cell,number,custom" to pad
> a cell with a predetermined amount of trailing zero's and not leading
> zero's. A...Date/Text Formatting
I have a column with in date format and would like to get
this into a text format as follows :
Column would say : 01/03/04
I want text to say : 'The month is March'
Any help would be appreciated...
One way ..
Assuming dates are in col A, A1 down
Put in B1:
="The month is
Please respond in thread
xdeme...How Draw a chart showing the following function: y=sin(x)
Can someone explain me how can i make this chart i excel?
Remember i don't want use function to count! I want draw!
Thanks for hel
PusieK's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1621
View this thread: http://www.excelforum.com/showthread.php?threadid=27630
For a variety of approaches adapt the ideas at
particularly the three sections:
Enumerating a set of points in a worksheet
Using...How do I hide zero values but keep currency format in P.O. form?
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only if
there is a value in the Quantity and Unit Price section. I formatted the
Total cells to Currency. But if there are no values in Quantity or Unit
Price, zero values appear in the Total cells. How do I format the total cells
to only show price values when there are values in Quantity and Unit Price?
When you format a cell as currency you get a custom format like this
(depending on the otpions you chose)...
Choose the ...Default Page Format set to custom, can't change.
Operating System: Mac OS X 10.5 (Leopard)
About six months ago I created a custom page setup in Word (4x7 inch). Now excel is always opening new documents in this custom format. I've gone into page setup and changed it, then saved it... nothing. I've checked the settings in the printer dialog under system preferences... all fine. <br><br>Any ideas how to get this back to opening in the standard letter size?
Is your installation of Office fully updated? 12.2.3 is the current level &
I seem to recall an issue several revisions ago wh...format cell
how to enter a line feed into a cell?
want to enter like the following into one cell
this is a test.(CR LF)
this is a test
this is a test. this is a test
..."Too many formats used"!!!
I have a large spreadsheet with multiple input forms which is almost complete. I am unable to progress further as Excel will not allow me to format any more cells with a "Too many formats used" message being displayed
I understand that I need to reduce the amount of formatting that has been used, but my endeavours to do so simply pops up the same message.
Is there a simple way to reduce the number of formats used in a spreadsheet either globally or per worksheet? Or any other solutions to this problem
Any help would be greatfully appreciated.
for dealing with too many cell for...IRR function
When we calculate an IRR using the IRR function with
yearly and monthly cash flow payments we are getting very
different results. The monthly payments sum up to the
Any insight would be appreciated.
Since you don't use dates with IRR, it calculates the return *per period*,
i.e. monthly rate if you enter monthly cash flows, annual rate if you enter
only 1 cash flow per year. Are you taking that into account?
On Tue, 28 Sep 2004 06:01:27 -0700, <firstname.lastname@example.org>
>When we calculate an IRR using the IRR function with
>yearly and...Pasting Access table into Excel; can't use SUM function
We have 200+ Oracle database tables that we use to create queries and make
tables. We create select queries on a daily basis that are comprised of
approx. 8,000 to 14,000 records. We usually take this information and paste
it into Excel for analysis. Recently, we upgraded from NT 4.0 WS to XP Pro.
We noticed that when we now paste our information into excel, the formatting
is changed. Numbers that we could easily SUM before, no longer respond to
the sum function. When we use the SUM function, the function does not
recognize the cell as a number and responds with '0'. When...Send From function in Outlook 2003
Wondered if anyone could help with this?
I have my own Exchange account in Outlook for my personal emails, and I
also have another user account setup to send and receive mail.
Now is there any way of sending mail from the other account using my
personal exchange account. I have tried using the FROM field in a new
message but doesnt seem to work.
And I also need it not to show "on behalf of", so no-one would know it
has come from the other account?
the administrator needs to give you send as permission on the personal
account in ADUC.
"cruwyser" ...Excel graphs should allow copy & paste of individual bar formats
In excel graphs - bar charts, I make the last bar a hashed shading as it is a
forcast. To do this I select only the last bar and change its formating. At
the end of the month I want to change the format back to the same as all the
other bars and make the new coming month's predicted value that hashed
Unfortunately excel will not allow copy and paste in this situation - so I
have do open the format tab etc and then change.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggest...Why color formatting not showing on worksheet?
I have a color printer and preview is in color. On-screen worksheet shows
only in black and white. What can be done to fix this?
Take a look at this:
>I have a color printer and preview is in color. On-
screen worksheet shows
>only in black and white. What can be done to fix this?
Look at this KB article
Changes to fill color and fill pattern are not displayed in Office programs
(remove nothere from the email addres...FRx row format account labels
When an FRx row format is created by using "Edit...Add Rows from Chart of
Accounts" and so forth, how does FRx determine the name of the account to
place within the row?
What I'm getting at is that a row format that is based on the natural
account segment can represent several accounts--for example, an account that
represents several departments--can be "divided" into different departments
based on the segment of the account.
So, for an account that has as many as ten departments, how does FRx
determine the name for the account. The account description ...convert into time format
I want to make a simple timetabel for my employees. Instead of time format
mm:ss I would like them just to type 1000 as in 10:00. I cannot find the
right way, and do not have expert skills in Excel. pls. help.
Cannot be done in Excel simply by formatting the cells.
You would have to use an adjacent column as a helper column with formulas to
make the change to time.
Chip Pearson has event code for quick entry of dates/times.
Or an add-in from Bob Phillips' site
Gord Dibb...Chart with conditional formatting
I have a spreadsheet that I am using to keep track of the RSVPs to a banquet.
The spreadsheet has the standard columns such as first name, last name,
company etc, I have also added columns for table # (the table I have assigned
them for seating at the banquet), a Y/N column to indicate if we have
received payment for the banquet and a Y/N column that shows if they are a
VIP or Speaker. What I would like to do is create a chart using conditional
formatting in worksheet cells. I envision having a row for each table number,
then a column that would represent each seat at the table (each ta...copy and paste formatting
I am copying and pasting individual files - over 100 of them into 1 file.
Each time I paste a new one in the file it keeps it formatting rather than
conforming to the format of the file it is being pasted into (ei font type
and size and margin settings).
Is there a way to paste it so that it automatically changes the format,
rather than keeping what it was in the original file?
Use Paste Special > Paste Unformatted.
On Mar 17, 9:51=A0am, Ruth <R...@discussions.microsoft.com> wrote:
> I am copying and pasting individu...customizing chart column color formats in code
I have some code that examines a set of data and generates a
x1columncluster chart. Depending on the set of data, I may have any
number of column clusters as a result. However, I currently format the
columns manually to make certain groupings a given color and another
group of columns a different color and so forth. I would like to
Is there a way to go through each column like for x = 1 to
If group = 1
set color accordingly
else set color differently
Did that make sense?
Perhaps you could use Jon Peltier's technique for conditio...Database results format problem
Hi I have an issue with a field [priceeuros] that reports out as a sinle
interger, no commas, can someone help please
This is the second page of the DBRW I am experimenting with, but there is a
SELECT * FROM Apmt1bed,
format([priceeuros],'Currency') as fmtamount,
ORDER BY PriceEuros ASC
I have 1234567 and want 1,234,567
thank you for your help
If you don't want the $ format, just use
Format(priceeuros,'#,##0.00') as fmtamount
______________________________...how do i format the cells so that all the blanks show -
hi i want to format the cells so that all the blanks or zero number
show a hyphon i.e one of these -
Message posted from http://www.ExcelForum.com
XL's format convention has 4 sections separated by semicolons. By
default these sections are for positive numbers, negative numbers,
zero, and text. To get what you want for zeros, choose
You can't format a blank cell to show a value (or then it isn't
blank). Instead, enter a hyphen (or zero) in the cells you don't
want another value in.
In article <sokevin...Question Regarding Excel 2007 Formatting Corruption
I am having a problem with Excel 2007 files losing all formatting
(merged cells, colors, borders, and data formatting (99% turns into
0.99)) when I open a file on our office server make edits and then
save the new file on the server. Each sheet usually has a mix of
locked and unlocked cells and I unprotect the sheet to make edits.
Also, something is fundamentally changed with the file as its size
doubles or triples. If I reopen the corrupted file and redo any of
the formatting and try to save it none of the new formatting is
retained either. Has anyone else ever experienced a pr...Time Format #6
I'm having a problem adding together journey times.
I have a start time (say 8:34:00) and an end time (say 10:23:00) and from
this I calculate a journey time (1:49:00). I then add this journey time
(using the sum function) across a number of different journeys giving me a
total. This total is in some case in excess of 24 hours and Excel seems to
revert to 0 at 24 hours and start the sum again. So for example I can see
when I highlight the range that the total is 27:49:00 but the sum function
Use a custom format:
The ...Default Cell Format Hijacked to Scientific?
When I type in the number 12 on a new sheet I get: 1.2E+45
When I change the format to number I get:
I can't seem to fix this. Help!!
Social Studies Teacher/Web Master
Murry Bergtraum High School
Look under tools>options>edit and uncheck fixed decimal places
"john elf" <email@example.com> wrote in message
> When I type in the number 12 on a new sheet I get: 1.2E+45
> When I chan...Conditional Formatting Error
Appreciate it if some experts could tell me what wrong with m
conditional formatting (CF) formula. In Col A, I have dates (se
example below). I want the current week to be highlighted with
My current CF for A1 cell is something like this:-
However, I encounter this error and Excel would not allow me t
"You may not use references to other worksheets or workbooks fo
Conditional Formatting criteria".
I am not making any references to other worksheets or workbooks.
 10-May-04 <-- this...Excel worksheet function
Can I protect my worksheet in Excel and enable the spell function...
Only by using VBA macro code.
Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
If not familiar with VBA and macros, see David McRitchie's site for more on