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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
16 digit number wont keep alteration unless format cell to text by Croc001
Using excel 2000 recieving data from client with 16 numeral characters within cells cells show an abreviated listing for the number (2.06E+15) When editing the...
March 30th, 2005 09:12 AM
by [email protected] Go to last post
3 356
number formats default to 2 decimal points when entered so 24 bec. by kiddo7us
number formats default to 2 decimal points when entered so 24 becomes 0.24. A number setting would seem to be the problem but I cannot find anything that can...
March 30th, 2005 09:48 AM
by Niek Otten Go to last post
1 214
Calculate minus figures only by Nigel
i need to know how to do the following calculation. i need to calculate the minus figures only and leave to positive figures. these figures are inserted random...
March 30th, 2005 10:31 AM
by Nigel Go to last post
0 436
calculate minus figures only by Nigel
Can anyone help me to calculate the minus figures only in a range of random costs? example £-2000.00 £ 1000.00 £ 560.00 £-4500.00 £-6500.00
March 30th, 2005 12:03 PM
by Nigel Go to last post
2 98
Creating Calculations Within a Field by MinhPhan
Hello, I have an Activity field with various activities and I would like to calculate the time values between these activities. For example: Activity (Field)...
March 30th, 2005 12:30 PM
by JulieD Go to last post
9 133
If then VBA by nc
Hi Can I simplify the codes below, is it possible to use Select Case? Thanks. On Error Resume Next Range("B1:B500").Find("Product ").Select
March 30th, 2005 01:27 PM
by nc Go to last post
2 96
Multiple workbook user's with Master workbook - all password protected by Yvon
Hello, Using Excel 2000. This is the situation...I have 17 different workbooks representing 17 people's salary all linking to a summary workbook for my...
March 30th, 2005 01:34 PM
by Yvon Go to last post
2 256
broken links message still popping up by GJR3599
i am attempting to call data from a source (input workbook) into a workbook (called the output workbook) and when i start up the output workbook after i am...
March 30th, 2005 01:36 PM
by Dave Peterson Go to last post
1 257
March 30th, 2005 01:41 PM
by Dave Peterson Go to last post
1 89
MAIL MERGE by vishu
I’ve done mail merge between word and Excel. I have data in excel that should display in word document. I have typed some number say for example 300.63 But...
March 30th, 2005 01:43 PM
by Dave Peterson Go to last post
1 84
When Copying Excel Table to Powerpoint by Alicia
When I try to copy a excel table using the "Shift + Copy" Function an error message appear that picture will be Truncated and part of the columns never appear...
March 30th, 2005 01:44 PM
by Dave Peterson Go to last post
1 175
Date format of cells by Alex
I am downloading a result to excel and there are date formats in that result. When I copied thedate formatted cells and paste it to a...
March 30th, 2005 01:47 PM
by Dave Peterson Go to last post
1 77
Time by zandj
HOW DO I CONVERT Hr:Mn TO Hr IN EXCEL ie 8:15 to 8.25? Is there a short cut? I am not hot on formulae in Excel
March 30th, 2005 01:49 PM
by vishu Go to last post
2 68
Please help by bao-bao
Hi, I have a talbe including two or more same name, I want to make it from: tom 10 Mike 10 tom 20 jerry 30 to: tom 30
March 30th, 2005 01:51 PM
by Dave Peterson Go to last post
2 88
Circular CallOut by Nesarkar
How do I create Circular or Triangular Callouts in MS Excel
March 30th, 2005 01:53 PM
by Dave Peterson Go to last post
1 90
Addition problem, number always 2 cents off...Help by WTG
I have a little problem with my SUMs I have 200 to 300 rows of A * B = C Then I tell it to do a =sum(d1:d300) All the cells are formated to currency, two...
March 30th, 2005 01:57 PM
by vishu Go to last post
3 153
Trying to create a Sales Projection/Forecast/Estimate by S L Pace
I'm trying to create a estimated sales pace for the month at my restaurant from a chart that has our daily sales in it. The current chart has the following...
March 30th, 2005 02:06 PM
by Dave O Go to last post
3 203
How do I format a cell to display measurement units with symbols . by Mandy
How do I format a cell to display measurement units with symbols in Excel 2000? (ie. " for inch, etc.) Thanks, Mandy
March 30th, 2005 02:19 PM
by Anton Go to last post
3 207
Auto Populate a cell by Bellsouth
If I enter "Electric" in cell d12 I want to have cell D14 auto populated with "N/A" Can this be done - how? Thanks Hank
March 30th, 2005 02:27 PM
by Hank Go to last post
3 205
Can't Copy and Paste between Excel 2003 Workbooks by wllee
We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets. When you highlight...
March 30th, 2005 02:59 PM
by wllee Go to last post
6 633
Post New Thread


Display Options
Showing threads 9801 to 9820 of 139764
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 10:22 PM.


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