changing 122- to -122 1

[tsd]

Does anyone have the query that would change the text field 122- to -122?<br><br>

 

[JimHorton]

It looks like a formatting issue to me...If you have negative numbers formatted with a trailing minus sign like you show, and want to change it to a leading minus sign, you'd need to set the format property of whatever textbox you display the value in.&nbsp;&nbsp;<br>This will format minus 122 as 122-:<br>#,##0.00-<br>and this will show -122<br>-#,##0.00<br>The second arg of the Format property tells what to do with negatives, so this is where you'd place you're choice of the above formats.<br>--Jim