Splitting values into different cells - not aligned in decimal correct places

**chrisumali** · 03-26-2013, 07:55 AM

Please help I will use this in our tax form, I want to show the amounts in its proper places

**etaf** · 03-26-2013, 08:01 AM

not sure why you have 2 sets of decimal in the desired output
or why you start extracting half way through the text in row 14 and 15 -so not sure i understand the business rules

**benishiryo** · 03-26-2013, 08:17 AM

hi chrisumali. i don't understand your desired results too. but this is what i suspect you're doing. try this in W13 & copy to all the cells you need:
=IF(LEN(TEXT($E13,"#.00"))<COLUMNS(W13:$W13),"",MID(TEXT($E13,"#.00"),LEN(TEXT($E13,"#.00"))-COLUMNS(W13:$W13)+1,1))