Solved

Formatting number to Text Format DDDDDDDDCC

Posted on 2016-10-31
1
36 Views
Last Modified: 2016-11-01
The bank wants the check amount in format DDDDDDDDCC

52.34
17754.35

I want:
0000005234
0001775435

I tried
ToText({chck.chck_amnt},'0000000000',2,"","")

and the results are:
0000000052
0000017754

{chck.chck_amnt} is a number field
0
Comment
Question by:Lisa Jasperse
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 41867649
Try this formula

Picture(Replace(Totext(12345.67,2,''),'.',''), '000000000000000')

Another way

Replace(ToText(12345.67,'000000000000000.00'),'.','')



mlmcc
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question