Using LEN and TEXT for format

[SuperFerret]

Hello,

I have an issue I am trying to solve with a formula, basically I have to pull a figure from another worksheet and format at TEXT...normally this is fine but somehow, some people managed to break it!

Is there a way to check the length of the original cell using LEN and use that with TEXT to pull the correct data?

E.g.

012345 something like: =IF(LEN(A1>0),Text(A1,"len(a1) in 0's"),"") pulls 012345 not 12345

 

[RoryA]

=text(a1,rept("0",len(a1)))

 

[SuperFerret]

Thanks Rory...er...Mary

I knew it'd be something simple!