[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Formatting Amount field on check

I am aware of the following money formatting.

$#,##0.00;($#,##0.00);"Zero";"Null"

I am printing a check and need the amount field to be preceded by (leading) either asterisks or dollar signs on the amount field that will move in and out depending on the amount.

Like:

****1,000.00
******100.00
and so on.

Can anyone help ?
0
proffittware
Asked:
proffittware
  • 2
  • 2
1 Solution
 
peter57rCommented:
You can use an expression to create the field.

right("**********" & format(fieldname, 0.00),10)
0
 
proffittwareAuthor Commented:
Peter57r....been having syntax problems ...working on it...get back...
0
 
peter57rCommented:
Sorry= missed some ""

right("**********" & format(fieldname,"0.00"),10)

Example form immediate window...
x=1.23
?Right("**********" & format(x,"0.00"),10)
******1.23

0
 
proffittwareAuthor Commented:
Thanks.... I have made these adjustments but thanks again....

=Right("**********" & format(x,"#,#00.00"),14)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now