Excel Issue

[pratiksuhasaria]

In a Cell the value stored is 00.00 n the number_format is text. But when i try to replace " . " with space it results in single 0.
My requirement is that I should get this 0000 when I replace dot with space
Plz help

 

[Yongle]

Does this formula work for you?


=TEXT(VALUE(A1)*100,"0000")