what function to convert convert 34234 to 99999

Hi all,

I'm stuck in converting number to 9

for example:
34234 to 9999
i've tried with ceiling function, and it works, but i have to enter 99999 so i can convert 34234 to 99999.
is there anyway for me to get the conversion done without having me to write 99999?

thanks in advance

Hi,

it works great, i use the "=REPT(9,LEN(A1))" i tried with the function but it came out value.

thank you!