Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

number formatting formula help

Status
Not open for further replies.

buddyel

MIS
Mar 3, 2002
279
US

I am working on a report for QTD wages and local taxes that needs to be submitted to the City. They need the wages in the following format, does anyone have an idea on how to do this?

WageQTD They Want
7412.25 00741225


The field is supposed to be 8 digits, filling blank spaces with a ZERO!!!
 
Hi !

If it is ok to convert it to a string field then you can use the following formula:

ToText({YourField} * 100,"00000000");

/Goran
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top