After you select a format, the Property Update Options button appears, and lets you to apply your new format to any other table fields and form controls that would logically inherit it.To compress that visual representation in Excel – I select the header row – right-click, choose format cells, and then choose Alignment – and set the bar pointing up – or 90 degrees. The data columns are presented in Gig – so I would only see 1 or 2 digits per cell – I.E.If there is a way to always default to “Match Destination Formatting” or if it can be done with a VBA macro so that each time I hit “ctrl +V” keys to always default “Match Destination Formatting”. And you have to manually change it to “Match Destination Formatting”.If you select Currency, or another specialized format, all the numbers, including dates, will get that format. TIP: For number formatting, select General, so dates and numbers will look best. Click OK, twice, to close the dialog boxes. Click the Format button, and change any of the Cell formatting options.Microsoft Excel Visual Basic.NET 9 Comments. Excel 2010 VBA - formatting Currency in a message box.How To Convert Text Box Value To Integer? You can easily convert string value from TextBox Control with this line of code: int MyInteger = Convert.ToInt32(TextBox1.Text).