# Crystal reports - alpha to numeric

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-03-13 19:18 UTC
**Views:** 331
**Replies:** 1
**URL:** https://www.epiusers.help/t/crystal-reports-alpha-to-numeric/2442

---

## Post #1 by @system

<div id="ygrps-yiv-1438896612">Create a formula called something like OrderRelNum.<br/>
The formula would be ToNumber(OrderRel.OrderRelnum)<br/>
<br/>
Then sort the report using the formula @OrderRelNum instead of the field.<br/>
<br/>
<br/>
Troy Funte<br/>
Liberty Electronics<br/>
<br/>
<br/>
<blockquote><span title="qreply">   ----- Original Message ----- <br/>
  From: Dunn, Nancy <br/>
  To: Vantage Onelist (E-mail) <br/>
  Sent: Tuesday, March 13, 2001 4:36 PM<br/>
  Subject: [Vantage] Crystal reports - alpha to numeric<br/>
<br/>
<br/>
  I&#39;m sorry to have to ask again, but I can&#39;t find the answer in the archives.<br/>
  I am trying to change the OrderRel.OrderRelnum field to a numeric field in<br/>
  Crystal reports so the Release numbes sort correctly.<br/>
        Sort like this     Instead of this<br/>
              1            1<br/>
              2            10<br/>
              3            11<br/>
  What was the formula?<br/>
  On version 4.904  Crystal reports ver8<br/>
  Thanks<br/>
  Nancy Dunn<br/>
  Winco Industries Inc<br/>
  <a rel="nofollow" target="_blank" href="mailto:ndunn@...">ndunn@...</a><br/>
<br/>
<br/>
        Yahoo! Groups Sponsor <br/>
<br/>
        Click Here to Find Software Faster <br/>
       <br/>
<br/>
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. <br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed] </span></blockquote></div>

---

## Post #2 by @system

<div id="ygrps-yiv-196382648">I&#39;m sorry to have to ask again, but I can&#39;t find the answer in the archives.<br/>
I am trying to change the OrderRel.OrderRelnum field to a numeric field in<br/>
Crystal reports so the Release numbes sort correctly.<br/>
 	Sort like this     Instead of this<br/>
		1		1<br/>
		2		10<br/>
		3		11<br/>
What was the formula?<br/>
On version 4.904  Crystal reports ver8<br/>
Thanks<br/>
Nancy Dunn<br/>
Winco Industries Inc<br/>
<a rel="nofollow" target="_blank" href="mailto:ndunn@...">ndunn@...</a></div>

---


**Canonical:** https://www.epiusers.help/t/crystal-reports-alpha-to-numeric/2442
**Original content:** https://www.epiusers.help/t/crystal-reports-alpha-to-numeric/2442