Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mass changes to numeric fields Expand / Collapse
Author
Message
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: Wednesday, November 5, 2014 10:37 AM
Points: 37, Visits: 210
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?

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


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 86, Visits: 760
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
'$'0.00;('$'0.00)

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

Add to briefcase

Permissions Expand / Collapse