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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scaling fields

Status
Not open for further replies.

DanielMcCarthy

Technical User
Sep 8, 2000
9
US
I have a field that reads similar to the following: 00123450. The last two positions are decimal places, but there is no decimal stored in the field, is there a function I can use to insert a decimal there?
[sig][/sig]
 
Why do not you create formula to be so? It is very easy, just divide that number by 100 to get the 2 decimal places you want. The formula would be as follows:

00123450 / 100

Does this answer your question, or were I not able to understand your question? I hope that would help. :) [sig]<p>Ossama Gharib<br><a href=mailto:eek:gharib@link.com.eg>ogharib@link.com.eg</a><br><a href= to Link Development</a><br>[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top