| Turning a single digit number into a double digit number Google spreadsheet array! | teadby | 7/1/12 9:12 AM | I have a column of double and single digit numbers in the A column starting with A2. 113561 I want to copy them to the B column in a double digit format. at the moment i am using =ARRAYFORMULA(IFERROR(TEXT( A2:A ; "00" )))in b2. This gets A B1 0113 1 |
| Re: Turning a single digit number into a double digit number Google spreadsheet array! | Yogi Anand | 7/1/12 9:40 AM | Hi teady: one way ... =arrayformula(if(A2:A,text(A2:A;"00"),)) Cheers!YogiCloud Computing -- Google Docs http://Wayyogi--anand-consulting.blogspot.com |