Excel TEXT formatting

[kis]

Hello,

I want to use TEXT function in excel to format a number like -99.9854
to xxxxxx-99.9854 where 6 x's are 6 trailing white spaces. The number
is in the range -99999.9999 to -0.9999. Any body can help please?

KIS

 

[kis]

Thanks, this is what I want.

Maybe it's a language thing.  You write "trailing white spaces" but your x's are in the "leading" position.

To have your value show as text with six leading spaces, try one of these:

=REPT(" ",6) & TEXT(A1,"General")

=TEXT(A1,"""      ""General;""      ""-General;""      ""General")

General can be replaced, in either formula, with a more defined numeric format.