Excel Busn Math 08: Whole, Decimal Numbers & Formatting

Hello,

The problem I am having is that I have a large amount of data that was copied and pasted from one excel spreadsheet to a different one (I am using Excel 2003). If , for example, the original number I copied was 0.00065, it shows up in the new spreadsheet as 0 (it will show as 0 in the cell on the new spreadsheet, but when you look at the equation bar, the original number, 0.00065, will show). I know this can be fixed by individually fixing each decimal place, however I am working with thousands of numbers, and want to know if there is a way for me to highlight all of the numbers (most of them have different decimal places), and format them all at once so that they show the actual number?

Thanks

I installed SP2 for office 2003 yesterday and now anything I type into my
excel workbook shows up with .45 instead of 45 which I typed in.. Any ideas?

Maybe I didn't explain it properly. I have about 300 computers that have
mostly 3 number designations, something like tnc314 and then I have 100 of
them that have numbers like tnc3148. Now when I sort, the 3 and 4 number
computer names are all bunched together. How can I have the 3 number names
sorted by itself, and then the 4 number ones on the end. All in sequence of
course. Your help is very much appreciated......Peter

Hi,

as said in the title, I am looking for a way to stop excel 2007 from stopping to auto convert hexadecimal numbers to exponential numbers.

quick example would be

3566E98 to 3.57E+101 :-(

add. information(any other needed pls ask):

- it's a shared spread(ss) used by +20 people the same time
- numbers are c&p'd to ss

appreciate your help

I need code to attach to a button!

In cell A1 I enter number of teams.
In Cell A2 I enter number of games to play.
Is there a way for me to click a button and...
In columns A and B it will give me a list of teams to play each other
based on the criteria above.
In Column A will be home team and B is Visitor.

Example I enter 9 teams with 12 games to play, hit the button and it will list the games in columns A and B.

If I need to explain more, I can.
Any help on this would be great!

Michael

I have a vba macro that takes data from one workbook and pastes it into another workbook. In doing this I have declared a few variables of type single (I only need two decimal precision). However, when I copy the values from the cells on the source workbook and paste them into the target workbook, the numbers end up having 12 decimal places. Ultimately, this extra precision causes my totals to be off by .01 or more after a while. I have tried rounding the number as I pull it off the source workbook into the variable, but that didn't matter. How do I solve this problem?

Code for pulling data from source workbook:

Code:

    Select Case product_class
        Case 1
            lbs_of_product_cl1 = Round(lbs_of_product_cl1 + Selection.Value, 2)
            Selection.Offset(0, 4).Select
            butterfat_cl1 = Round(butterfat_cl1 + Selection.Value, 2)
        Case 2
            lbs_of_product_cl2 = Round(lbs_of_product_cl2 + Selection.Value, 2)
            Selection.Offset(0, 4).Select
            butterfat_cl2 = Round(butterfat_cl2 + Selection.Value, 2)
    End Select

code for pasting the data into the target workbook:

Code:

Selection.Value = lbs_of_product_cl1
Selection.Offset(0, 1).Select
Selection.Value = butterfat_cl1
Selection.Offset(0, 1).Select
Selection.Value = lbs_of_product_cl2
Selection.Offset(0, 1).Select
Selection.Value = butterfat_cl2

Thanks

Greetings all!

This is probably an easy question for the experienced, but could someone tell me why: When I dimension a numeric decimal value as a single or double in VBA code (such as 5.05, etc.), why does excel turn it into 5.0499999999999998?

I've tried using the round function as cleverly as I can, including changing the number from 5.05 to 5.051 and then rounding to 2 decimal places, but it doesn't make a difference.

I'm thinking that the issue is with excel because I'm using the value(s) in the spreadsheet to populate fields on a Word mail merge main document and even when the Excel cell displays the correct value in the cell (5.05), the value in the Word merge field ends up 5.0499999999999998. Not to mention, sometimes even though the correct value is in the cell, when it is selected as the active cell the value that appears in the formula bar is not 5.05 but 5.049999999999999998.

Anyone have any ideas as to why this is happening? I have other hard coded values within the code and they work just fine, but they're positive, whole, real numbers.

Thanks in advance for your time!

--Patrick

I have a userform with a TextBox that enters data into the active cell. I
have also a validation of the data to check that only numbers are entered.

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
If Not IsNumeric(TextBox1) Then
MsgBox "Only numbers"
TextBox1 = vbNullString
Cancel = True
End If
End Sub

All this looks to work fine.

If the number entered is an integer the number is recognized as a number
(active cell is a part of SUM formula to verify this).
If the number in the TextBox1 is a decimal number like 123,45 (yes, I live
in a country that uses ,-comma as decimal symbol and regional settings
reflects this) the validation accept is as a number, but the active cell
does not see it as a number but as text (the SUM formula shows that it is
not seen as a number).
If I go to the spreadsheet, double click in the cell that contains 123,45
and then select another cell in the spreadsheet (make no changes to the
cell containing 123,45) THEN the spreadsheet recognize 123,45 as a number
and udates the result of the SUM formula.

I have tried to format the active cell after the number has been entered:

ActiveCell.NumberFormat = "# ##0.00;(# ##0.00)"

but this doesn't help.

All help will be appreciated.