Home 
Search 
Today's Posts 
#1




divide numbers up for a paper form
Ok, here are two separate form problems I have.
Form 1 requires whole dollars in one column, and the cents in another. ie 27,651.09 needs to be "27,651" in one column and "09" in the one right next to it. These numbers are formula driven totals calculated elsewhere that must be transformed for this one form, as archaic as the form happens to be. Form 2 is worse, this would take a number like "27,651.09" and divide it one digit at a time for the approximate box on the printed form. ie 2765109 I tried =text type formulas with the idea of extrapolating which places I needed for the respective boxes, but that is not working out well. Ideas greatly appreciated. Bruce 
#2




divide numbers up for a paper form
Suppose your calculated value is in A1. This will give you the integer
value: =INT(A1) but if you need it as text then do this: =TEXT(INT(A1),"#,##0") The following will give you the cents, with leading zeros preserved: =TEXT((A1INT(A1))*100,"00") Hope this helps. Pete On Aug 23, 7:52*pm, Revenue wrote: Ok, here are two separate form problems I have. Form 1 requires whole dollars in one column, and the cents in another. ie *27,651.09 needs to be * "27,651" in one column and "09" in the one right next to it. These numbers are formula driven totals calculated elsewhere that must be transformed for this one form, as archaic as the form happens to be. Form 2 is worse, this would take a number like "27,651.09" and divide it one digit at a time for the approximate box on the printed form. ie * 2765109 I tried =text type formulas with the idea of extrapolating which places I needed for the respective boxes, but that is not working out well. Ideas greatly appreciated. Bruce 
#3




divide numbers up for a paper form
On Aug 23, 4:23*pm, Pete_UK wrote:
Suppose your calculated value is in A1. This will give you the integer value: =INT(A1) but if you need it as text then do this: =TEXT(INT(A1),"#,##0") The following will give you the cents, with leading zeros preserved: =TEXT((A1INT(A1))*100,"00") Hope this helps. Pete On Aug 23, 7:52*pm, Revenue wrote: Ok, here are two separate form problems I have. Form 1 requires whole dollars in one column, and the cents in another. ie *27,651.09 needs to be * "27,651" in one column and "09" in the one right next to it. These numbers are formula driven totals calculated elsewhere that must be transformed for this one form, as archaic as the form happens to be. Form 2 is worse, this would take a number like "27,651.09" and divide it one digit at a time for the approximate box on the printed form. ie * 2765109 I tried =text type formulas with the idea of extrapolating which places I needed for the respective boxes, but that is not working out well. Ideas greatly appreciated. Bruce Hide quoted text   Show quoted text  datatext to columnsdelimitedother = . 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
how to divide numbers  Excel Worksheet Functions  
Can I scan an existing paper form into excel  Excel Discussion (Misc queries)  
DIVIDE NUMBERS EVENLY  Excel Worksheet Functions  
Numbers divide by 10 in any cell...  Excel Discussion (Misc queries)  
My excel2000 divide numbers per 10 why?  Excel Discussion (Misc queries) 