View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
0-0 Wai Wai ^-^
 
Posts: n/a
Default "000" + number + "."


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