software

Hi.
Here's the number list.
5
203
3450
4498
12358

This time, I need add extra quot;0quot; to the number until it has 6 digits amp; a dot at
the end of the number, eg:
5 --gt; 000005.
203 --gt; 000203.

How to do?
Thank you!--
Additional info about my computer:
- Office XP
- Windows XP Pro
One way

=TEXT(A2,quot;000000.quot;)--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;0-0 Wai Wai ^-^quot; gt; wrote in message
...
gt;
gt; Hi.
gt; Here's the number list.
gt; 5
gt; 203
gt; 3450
gt; 4498
gt; 12358
gt;
gt; This time, I need add extra quot;0quot; to the number until it has 6 digits amp; a
gt; dot at
gt; the end of the number, eg:
gt; 5 --gt; 000005.
gt; 203 --gt; 000203.
gt;
gt; How to do?
gt; Thank you!
gt;
gt;
gt; --
gt; Additional info about my computer:
gt; - Office XP
gt; - Windows XP Pro
gt;
gt;
=TEXT(A1,quot;000000quot;)amp;quot;.quot;

--
Kind regards,

Niek Otten

quot;0-0 Wai Wai ^-^quot; gt; wrote in message ...
|
| Hi.
| Here's the number list.
| 5
| 203
| 3450
| 4498
| 12358
|
| This time, I need add extra quot;0quot; to the number until it has 6 digits amp; a dot at
| the end of the number, eg:
| 5 --gt; 000005.
| 203 --gt; 000203.
|
| How to do?
| Thank you!
|
|
| --
| Additional info about my computer:
| - Office XP
| - Windows XP Pro
|
|

quot;Niek Ottenquot; gt; ¦b¶l¥ó¤¤¼¶¼g...
gt; =TEXT(A1,quot;000000quot;)amp;quot;.quot;

Excellent!
The 000000 works like a charm!
Thanks!
Thanks for your help!