Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Mass changes to numeric fields Expand / Collapse
Posted Friday, December 20, 2013 3:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 19, 2015 8:16 AM
Points: 39, Visits: 223
I have multiple numeric fields that are decimals. I need to change the output to currency, right align the data and put the dollar amounts on the bottom. At best this is tedious since I have to do 20 fields exactly the same. Right now I open each field and make the changes. Is there a way to make mass changes to the data that uses the same formats?

Post #1525198
Posted Friday, December 27, 2013 6:51 AM



Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 184, Visits: 1,298
You can just click to select the fields (press and hold Crtl to select multiple fields) and then change these properties in the properties sidebar (press F4 to make this appear).

You can then enter the text for the currency format in the Format property , it would be something like

The TextAlign property can be used to adjust the alignment etc.
Post #1526123
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse