Prevent scientific display

[scele]

I have a lot of entries (personal identification numbers) and all of them are formatted as NUMBER. Now, I must convert it to TEXT format, but when I convert them, they change to scientific numbers. I know that value in the cells is the same, but please, is there any way to keep displaying cells as they are (eleven-digits), even if they are in TEXT format.

Sorry for my bad english.
Ivan

[Niek Otten]

=TEXT(A1,"#")

--
Kind regards,

Niek Otten

"scele" <[email protected]> wrote in message
news:[email protected]...
>
> I have a lot of entries (personal identification numbers) and all of
> them are formatted as NUMBER. Now, I must convert it to TEXT format,
> but when I convert them, they change to scientific numbers. I know that
> value in the cells is the same, but please, is there any way to keep
> displaying cells as they are (eleven-digits), even if they are in TEXT
> format.
>
> Sorry for my bad english.
> Ivan
>
>
> --
> scele
> ------------------------------------------------------------------------
> scele's Profile: http://www.excelforum.com/member.php...o&userid=33177
> View this thread: http://www.excelforum.com/showthread...hreadid=529954
>