Strange Round Off Error
Jun 16, 2006when mixing data types: a real and a complex as in
=IMSUM(-G1/2,IMSQRT(H1))
if G1 and H1 are both exactly equal to 4, the answer whould be 0
see [url]
and look at location I1 (highlighted).
ADVERTISEMENT
Remove A Strange Scroll Bar
Feb 27, 2009I dont know the real name about this scroll bar (like you can see in my attachment), so I cant search in the forum, sigh! how can I remove the bar in the red circle?
View 3 Replies View RelatedStrange INDEX Phenomena?
Oct 8, 2009INDEX(Sheet1!$F$2:$F$10,0,1) returns #VALUE!
INDEX(Sheet1!$F$2:$F$100,0,1) returns 110 (e.g.)
As Both index have zero(0) for its row reference (row_num) I would expect both formulas to return #VALUE! (or even #REF!)
Strange Characters Appears
Sep 16, 2009there is a strange character that appears in an excel spreadsheet. It looks like a square with a question mark in it.
what this means and am I able to remove them
Strange Characters Equal EOF
May 28, 2006I made a userform that spits out 'logs' in a more readable easy to understand. It basically shoves everything into a nicely organized list box.
I have a load button that if pressed accepts .csv's
It works perferctly for practically every type of .csv that contains these logs however 1/100 times the logs contain korean or chinese characters which cause the program to crash.
I gone through some debugging and I found out that the characters that cause it to crash happen to equal the EOF character. So not only does it spit an error on that line, it stops loading anything after that point.
Here is my CheckFileSize function that runs first to tell me how long I should make my list.
Private Function CheckFileSize(ByVal TempFileName) As Double
Dim TempData As String
Dim SizeCount As Double
how to do this besides loading it into a worksheet first?
Strange Thing Only On One Computer Running This XLS
Feb 4, 2009Copy of the scaled down Workbook are enclosed. Password is "j". Sheet("Final Schedule") is one of 11 sheets in the Workbook. Range("a10: BE120") is copied from another Sheet and pasted.
ISSUE BACKGROUND: Entries into cells are Data Validation and a drop down on each cell. In cells C15, 16, 17, 18 or O15, 16, 17, 18 First time the Sheet is opened: user has no problem if they select a D from the drop down.
ISSUE:
But if user types in D and hits enter key, contents of G10: M10 (merged cells) is copied into that cell. Any thoughts on where to check or what settings to check? It only happens on that one computer.
Today Function Works Strange
Aug 24, 2009I have a column, where i want to calculate the difference between today and another date/or viceversa. The problem is, that in the first two cells, it calculates it well, but then, it shows #VALUE and when I press to see the "calculations steps" , it shows "29/09/2009"-40049. It turns the today function into a number. Why?
View 11 Replies View RelatedReferencing To CSV File In Strange Format
Oct 21, 2009I am working on an excel dashboard to display life information about energy consumption.
there is currently a bespoke syatem which does this but we need the dashboard to be changed so the job has fallen to me.
Energy usage across the site is recorded in a spreadsheet (automatically) every half an hour and is saved in a folder named CSV data, however the files are saved in a format which i assume is something for the current package: *.ew7
I can open and view the data by clicking "open as" and selecting excel.
I can reference to this data from another excel spreadsheet (dashboard) whilst they are both open it will update.
However when i close all spreadsheets and open just the dashboard it tells me that the links cannot be updated.
I need a solution or a way around this so i can reference from one workbook to another.
Has anyone had any experience of this kind of thing? can anyone offer a humble analyst a bit of advice?
I was not able to attach the file here (as its in the ew7 format) but i have uploaded it to rapidshare for anyone who wants to take a look...
Strange Characters Pasting To Textbox
Dec 20, 2006it is a very simple marco. It contains a textbox input within a user form. The only problem I have is, when I use CRTL-V to paste some text into the textbox, it has a wired character attached to the end of the text.
for example, I highlighted an email address (ex. abc@abc.com) from an email, use CRTL-C to copy, and I make sure that there is no space after the .com, and after I pasted using CRTL-V to the textbox, a wired character, like a reversed P sign..... very much like the carriage return in MS Word, would anyone know how to avoid that or disable that extra character?
Increase In Decimals Returns Strange Result
Jul 21, 2006I have discovered a strange thing about excel and it is driving me mad and ruining my project.
Basically, If i enter the number 97.4 into cell A1 and then 97.165 into cell B1 and then enter the formula =A1-B1 into cell C1 i get the answer 0.235. Which is correct.
However, when you increase the number of decimal places to 30 the answer that is returned is 0.234999999999999000000000000000.
This calculation result seem to fluctuate wildly depending on the primary numbers in cells a1 and b1. Very rarely have i seen the full 30 decimal places without a bizarre result like this.
Maybe it has been too many years since i was at school and that i am confused with my numbers and that there is a real easy answer to why this result is returned.
As i said it is ruining my project that i am working on. Can anyone help? Why does excel do this? Is there a way to stop this happening? My project relies on this answer to be correct. Is there a way to force excel to stop doing this?
To Rid Fields Of Strange Social Security Numbers
Mar 16, 2007weeding out a huge file I have of 10,000 users. When the usernames and social security numbers were entered originally, there were many mistakes on the social numbers, some were longer than 9 numbers and some were shorter....well now I need to delete the rows of the numbers that are nonsense, so I need help in finding or creating a script that goes thru my XLS file and strips out all the rows with less than 9 or more than 9 characters....can someone direct me on how to do this? here is an example of what im talking about
484818227 | John | Doe |
283298383 | Bob | Smith |
2039022221 | James | Dean | <--------need this row removed
293938832 | Billy | Bob |
29832E | George | Bush | <--------need this row removed as well
Bulk Convert Strange File Format In Multiple Folders.
Oct 27, 2009I have a series of files in *.ew7 format (i know its a random program)
I have some code which i can run which will simply open the relevant file and save it as xls.
The files are saved in multiple folders in format "yymm" eg: 0910 - oct 09.
inside each folder there is a ew7 file for each day in rthe format: "01ddmmyy" eg 01271009 = 27th oct 2009.
I have folders going back as far as may 2002 (in folder 0205) and i need a way to convert these all into xls format and save them in the same location.
Macro Worked For 2 Years, Suddenly Started Giving Strange Results
Jan 20, 2009I have a VBA macro that I pieced together* a couple of years ago to help with a pretty simple task. We have two excel sheets that pull in information daily from different sources. The macro copies and paste values for the worksheet, then 1) saves a copy of the values only worksheet with the current date, 2) resaves the values only worksheet as a .csv file that is then manually uploaded into our database.
View 3 Replies View RelatedVBA Round Function Vs Worksheet Round Function
Oct 24, 2006I don't know if there is a setting I'm missing or I'm going mad but when I use the round function in VBA it doesn't round.
I am using Excel 2000. See the example attached.
In the cell A2 I have a value 0.525, cell B2 has a formula "=round(A2,2)" which = 0.53, but cell C2 is assigned via VBA ie
Sheet1.Cells(2, 3).Value = Round(Sheet1.Cells(2, 1).Value, 2)
and the result is 0.52??
How To Round Of Value In VBA
Sep 28, 2012Using vba how to round off the value e.g.: The number 582.356894 has to be rounded off to 582.4 ....
View 1 Replies View RelatedRound Up/round Down
May 12, 2009i have a list of minutes in cells a1-a5 say 123 256 147 158 235 divided by 60 giving a total of 15.3 hours. i want the hours to round up if over the. 5 mark or round down if under .5 how would i get the desired result?
View 2 Replies View RelatedRound To Odd /even In Vba
Nov 6, 2009A cell value is calculated via a formula in vba. I want to round the result down to the nearest odd number or down to the nearest even number, depending on conditions in an other cell. The result is already an integer.
View 8 Replies View RelatedRound Down
Jan 7, 2010Tried the code below to change figures from countless decimal figures to two, however excel is not having any of it,
Range("d:o").Select
Application.WorksheetFunction.RoundDown (2)
How To Round Up A Percentage
May 5, 2014Why is Excel not rounding up a percentage of 93.5 to 94?
View 6 Replies View RelatedRound To Whole Number?
Feb 3, 2014rounding the numbers. I am working on a quote in which quantity is arrived by dividing the sell price by Total sell price. The condition is the result (quantity) should always be a whole number, I can achieve that by cell formatting but when the calculation is done using handheld calculator the results are different.
I need the result to be same if using excel or handheld device i.e quantity in whole number.
Sum Literally :: Round Off
Dec 11, 2008Hi, I have this issue:
1.67 -> DISPLAY 2 ROUNDED
1.67 + 1.67 = DISPLAY 3 ROUNDED
but I would like to know how to sum 1.67 as 2
WANTED -> SUM 2 AS A NUMBER AND NOT A ROUNDED
2+2 = 4
I've been trying various combinations, but currently no joy
Round Up In Units Of 80!
Jan 11, 2009I need to work out how long the batten has to be so the roof sheets fit evenly, the measurement has to start from 1460mm and go up in increments of 80mm eg 1540mm, 1620mm, 1700mm and so on.
But the number has be closest increment of 80mm over the shed width if this makes sense, the size of the battens for 2400 width shed would be 2420mm but i need this to work out for any width shed not just 2400.
Round To The Nearest 5
Feb 20, 2009I am using the rounding function in excel and its rounding to the 10's, is there a way to round to the nearest 5?
View 4 Replies View RelatedCell To Round Itself..
Aug 5, 2009i want a cell to round itself. i have a form i'm filling out, based on a percentage of a dollar amount. when the formula calculates, it only shows the first 2 numbers past the dollar point. however, the cell still "knows" what the number is. I have several of these formulas on a spreadsheet, and the sum of them at the bottom of the page is NOT what would you would get adding up the numbers you see on the page, as it is calculating numbers you can't see.
View 5 Replies View RelatedRound Up Formula
Sep 24, 2009I am trying to do is have the roundup formula round up the result of a more complex formula BUT do it all inside of the same cell? The formula I have is in cell A1 and currently I have to have the cell that contains the round up formula (in cell A2) and have it reference A1. The complex formula is =((280283.47/798186.89)*(700*20*4)) and the result is -19,664.41 which I want to round up to $20,000. Is there a way to make this all occur in just cell A2 or am I stretching it?
View 4 Replies View RelatedRound The Numbers
Oct 7, 2009I have a number say:
156.9679628 then I go to format to change it to 2 decimal then it would show
156.97 and then I c&p that ... I still get 156.96796284 how do i just get
156.97
Use IF And ROUND In Same Calculation
Oct 23, 2009I'm creating a spreadsheet to calculate materials with the following columns Cost/10% of Cost/Customer Cost/Qty/Total cost.
I understand that whilst showing rounded to 2 decimal places excel stores more than this in the cell. which then throws out the Total cost by a few pence.
My research leads me to believe I need to use the ROUND function but I'm unsure which cell to use it or how.
Round To Two Numbers
Jan 26, 2010round to two numbers. i have this formula
View 3 Replies View RelatedRound Off A Date
Jan 27, 2010How do I take a date value and round it off to a fixed month and day of the year following the year entered.
Ex: In cell A1 I have a date: 12/28/2009
I want to round off the date to January 1 of the next year. So I need a function that would return 01/01/2010 (jan 1 2010).
Round Up All Values
Feb 11, 2010How do I get Excel to round up all values from .3 onwards. EG 2.36 to 3 and 2.29 to 2?
View 4 Replies View Related