| 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? |
| 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) | |||
Threaded Mode
