Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split numbers and decimal in 2 columns
One column for the dollars and the other for the cents? If so, use the Text
to Columns, Use Delimited as the split option (Step 1) and select Other, type in the decimal point in the blank to the right of the Other option in step 2. This is good, but how do i keep it in the colums is i introduce new data and how do i sum it up (the colums) to get a final number with decimals in there corresponding colums? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split numbers and decimal in 2 columns
Dollars in in B, cents in C, Data shown
Dollars Cents Cu Sum 7 56 7.56 3 44 11.00 2 24 13.24 45 23 58.47 C2: =SUM($B$2:B2)+SUM($C$2:C2)/100 and copy down Regards Peter A "yodochi" wrote: One column for the dollars and the other for the cents? If so, use the Text to Columns, Use Delimited as the split option (Step 1) and select Other, type in the decimal point in the blank to the right of the Other option in step 2. This is good, but how do i keep it in the colums is i introduce new data and how do i sum it up (the colums) to get a final number with decimals in there corresponding colums? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split numbers and decimal in 2 columns
If you split 200.50 into two columns using DataText to Columns with decimal as
separator, you now have cells with 200 and 5 which if added is 205 You no longer have 200.50 because the decimal point is gone. Gord Dibben MS Excel MVP On Mon, 23 Jul 2007 12:40:04 -0700, yodochi wrote: One column for the dollars and the other for the cents? If so, use the Text to Columns, Use Delimited as the split option (Step 1) and select Other, type in the decimal point in the blank to the right of the Other option in step 2. This is good, but how do i keep it in the colums is i introduce new data and how do i sum it up (the colums) to get a final number with decimals in there corresponding colums? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split number with decimal places into 2 columns | New Users to Excel | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
how to split one decimal pt integer off & to next columnin excel? | Excel Discussion (Misc queries) |