"000" + number + "."

0

0-0 Wai Wai ^-^

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

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

How to do?
Thank you!
 
N

Niek Otten

=TEXT(A1,"000000")&"."

--
Kind regards,

Niek Otten

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