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 Chriss Miller 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
Joined
Sep 8, 2000
Messages
9
Location
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:ogharib@link.com.eg>ogharib@link.com.eg</a><br><a href= to Link Development</a><br>[/sig]
 
I didn't think of that. It works great. Thanks [sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top