View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
yodochi yodochi is offline
external usenet poster
 
Posts: 7
Default 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?