If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I show leading zeros in a number field
"How do I show leading zeros in a number field"
I have a database that will generate a fixed length text file. in the number field, I must fill all 9 spaces with leading zeros. Example: the number 645.00 should show and print as 000064500 How do I do this? |
#2
|
|||
|
|||
How do I show leading zeros in a number field
"=?Utf-8?B?dGZpbmtsZWE=?=" wrote in
: , I must fill all 9 spaces with leading zeros. Example: the number 645.00 should show and print as 000064500 How do I do this? Format(SomeNumber * 100, "000000000") HTH Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add missing zero's to customer number | Johnnyb | Worksheet Functions | 3 | August 4th, 2004 02:47 PM |
Adding zero's to the beginning of a number | kukarooza | General Discussion | 5 | June 28th, 2004 07:39 PM |
Fractional Number Value in a field | Maria K | Using Forms | 2 | June 22nd, 2004 12:39 AM |
Leading Zeros | Richard | Worksheet Functions | 3 | October 23rd, 2003 11:03 AM |
Leading zeros | Shane | Worksheet Functions | 6 | October 22nd, 2003 09:48 PM |