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!

Text Function Rounding Up 1

Status
Not open for further replies.

Fiat77

Programmer
Feb 4, 2005
63
US
We have a function in Excel to return a Mainframe String

="T"&TEXT(G1,"0000000")&TEXT(H1,"0000000")&TEXT(I1,"0000000")&TEXT(J1,"00000000")&RIGHT(DOLLAR(J1,2),2)&TEXT(J1,"00000000")&RIGHT(DOLLAR(J1,2),2)

The problem we are having is that J1 is a numeric value and this string TEXT(J1,"00000000") rounds up so instead of getting 799584 which is the actual value of J1,
we are getting 799684

What can we do to adjust this formual so we get a Text format but it does not round up
 
Is it a decimal? If so use TEXT(INT(J1),"00000000")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top