I'm exporting to a text file, I have the specs set based on col width. I
have a col that I want to round up. When I view the text file the number has
been rounded up but the decimal is still there with 00's

Create a query that formats the number the way you want it, and export that
query.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.MDB" which illustrates how to do this.
You can download it for free here:
http://www.rogersaccesslibrary.com/f...ts.asp?TID=351

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"JoAnna" <(E-Mail Removed)> wrote in message
news:A5E95922-F750-4362-993D-(E-Mail Removed)...
> I'm exporting to a text file, I have the specs set based on col width. I
> have a col that I want to round up. When I view the text file the number
> has
> been rounded up but the decimal is still there with 00's