I'm trying to format a column for 9 didgit phone numbers. Could not find format under
Hello, I would like to create all A cells with a custom cell formatting. I have a million serial numbers looking like that. 1234-12-123-1234 In custom cell options it would look like that
If Excel's number formats don't work for you, you can create a custom number format.
When I try to enter a number in a cell or range of cells that have been formatted for 'NUMBER', no matter what number I enterI it shows zero. If I format a cell or range of cells for GENERAL, any
How can I create a custom number format that will give me decimals only when the number is not whole? I have a whole column of amounts (dollars) and I don't want to format each cell individually. So,