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!

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

format field

Status
Not open for further replies.
carranz

carranz

Technical User
Nov 17, 2006
40
US
I have a field in my results. this field holds number values. some of the value have decimals and some dont. I would like to have the field to hold 6 places and remove the decimals and had zeros at the end.

Does anyone know how to do this?
 
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Date Format Conversion
Replies
1
Views
129
rasETL
rasETL
donafran
  • Locked
  • Question
Is it possible Reuse a Reference Link to a Lookup stage for multiple fields?
Replies
2
Views
131
donafran
donafran
GJFNH
  • Locked
  • Question
Easytrieve - possible binary fields?
Replies
2
Views
81
papadba
papadba
H0bbes56
  • Locked
  • Question
Converting to Time Format
Replies
0
Views
35
H0bbes56
H0bbes56
InformaticaDW
  • Locked
  • Question
Date format in informatica
Replies
2
Views
55
ArtieChoke
ArtieChoke

Part and Inventory Search

Sponsor

Back
Top