mattmickle
Board Regular
- Joined
- Nov 17, 2010
- Messages
- 81
$555.56
I need to convert this dollar amount to a text string of 8 positions (6 for the dollar amount, 2 for the cents amount).
Should look like = 00055556 with the assumption that the last 2 positions are cents.
The =TEXT(B2,"00000000") returns 00000556, rounding the amount
I've tried =TEXT(TRUNC(B2,0),"000000"&TEXT(RIGHT(B2,2),"00") which works, until you have an even decimal amount.
$555.50 returns 00055501
I need the decimal amount to be converted to text "as is" and not rounded.
Any help would be appreciated!
I need to convert this dollar amount to a text string of 8 positions (6 for the dollar amount, 2 for the cents amount).
Should look like = 00055556 with the assumption that the last 2 positions are cents.
The =TEXT(B2,"00000000") returns 00000556, rounding the amount
I've tried =TEXT(TRUNC(B2,0),"000000"&TEXT(RIGHT(B2,2),"00") which works, until you have an even decimal amount.
$555.50 returns 00055501
I need the decimal amount to be converted to text "as is" and not rounded.
Any help would be appreciated!