I'm using Spreadsheet Gear to do some Excel programming. I want more control over number formats and it appears that I need to use the NumberFormat
property to achieve this.
I've seen suggestions that you can use "@
" to specify a string for example, but can't find a complete reference on this.
I'm guessing it's Excel specific as opposed to Spreadsheet Gear specific.
Can anyone help me to find a full reference, or at least a decent list?
In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select a cell or a cell range. On the Home tab, select Number from the drop-down.
Select the cells that you want to format. On the Home tab, in the Number group, click the dialog box launcher next to Number (or just press CTRL+1). In the Category list, click the format that you want to use, and then adjust settings, if necessary.
Here's a list of the Number Format Codes for Excel.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With