Solved

Formatting number to Text Format DDDDDDDDCC

Posted on 2016-10-31
1
49 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 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