Categories: Sheets : Ask a "how-to" question :

Turning a single digit number into a double digit number Google spreadsheet array!

Showing 1-2 of 2 messages
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.

1
13
5
61

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 B
1 01
13 13
5 05
61 61
00
00
00
00
00

how do i edit this formula or make a new one so it only enters information if there is a number in the A column (get rid of all the 00's that continue on beyond my entries)???





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!
Yogi
Cloud Computing -- Google Docs Way