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
="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