"000" + number + "."

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

0-0 Wai Wai ^-^ - 11 May 2006 21:55 GMT

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!

Signature

Additional info about my computer:
- Office XP
- Windows XP Pro

Reply to this Message

Peo Sjoblom - 11 May 2006 22:02 GMT

One way

=TEXT(A2,"000000.")

Signature

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

> Hi.
> Here's the number list.
[quoted text clipped - 12 lines]
> How to do?
> Thank you!

Reply to this Message

Niek Otten - 11 May 2006 22:05 GMT

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

Signature

Kind regards,

Niek Otten

| Hi.
| Here's the number list.
[quoted text clipped - 11 lines]
| How to do?
| Thank you!

Reply to this Message

0-0 Wai Wai ^-^ - 13 May 2006 22:10 GMT

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

Excellent!
The 000000 works like a charm!
Thanks!

Reply to this Message

0-0 Wai Wai ^-^ - 16 May 2006 18:06 GMT

Thanks for your help!

Reply to this Message