| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
"Garry" <(E-Mail Removed)> wrote in
news  (E-Mail Removed):> Thanks very much > > I cannot get the Right([CountOverGroup] & "00000", 5) to work > though > > The result is 00000 for some reason > > Cheers, Garry > > try Right("00000" & [CountOverGroup] , 5) > "Garry" <(E-Mail Removed)> wrote in message > news:RZ-(E-Mail Removed)... >> Hi, I have a text box thus >> >> =[Ref] & " " & [Code] & " " & [CountOverAll] & " " & >> [CountOverGroup] & " " & [Marker] >> >> This results in ABC 223 21 6 * >> >> I want CountOverAll and CountOverGroup to be 5 digits >> >> Result I require is ABC 223 00021 00006 * >> >> Also if Ref or Code is null to close up the string so there are >> no excesive spaces >> >> Thank you >> > > > -- Bob Q. PA is y I've altered my address. |
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Install dates formating using conditional formating? | Jerry Eggleston | Microsoft Excel Misc | 2 | 9th Nov 2005 06:49 PM |
| Formating Text changes formating of entire document | =?Utf-8?B?Uml0ZXNoIEt1bWFy?= | Microsoft Word Document Management | 1 | 6th Jul 2005 11:55 PM |
| Formating C without Formating D (Recovery) | =?Utf-8?B?VG9vIG1hbnkgdXNlcnM=?= | Windows XP Performance | 1 | 19th Apr 2005 05:40 PM |
| how to make two references to one string that stay refered to the same string reguardless of the changing value in the string? | Daniel | Microsoft Dot NET | 7 | 12th Nov 2004 10:08 AM |
| Re: Converting a string to a string that contains the ASCII values of each letter in the origional string | Frank Oquendo | Microsoft C# .NET | 0 | 31st Jul 2003 08:36 PM |
