Web Applications Asked on January 25, 2021
According to this Google help article, I should be able to do the following to apply custom number formatting in a Google Sheets document.
123
number format icon in the toolbar).Seems simple enough, but I don’t have a Custom number format when I click on the 123
number format icon, or go to Format->Number.
I do have Custom Decimals, but that only allows you to specify the number of decimals. In my case, I want a custom format that involves the percent symbol, e.g., 0.001234
is rendered as 0.1234%
.
I also have More formats and More currencies, but neither of those have Custom number format, nor anything that looks like what I want.
This option is only available in the "new Google Sheets".
In the new Google Sheets, you can apply custom formatting for currencies, dates, and numbers.
cf https://support.google.com/drive/answer/56470?hl=en
To activate the new Google Sheets, you can follow those instructions: https://support.google.com/drive/answer/3541068
Correct answer by Yom on January 25, 2021
click in a cell > Go to Format > Number > More Formats > Custom Number Format > type in exactly: (###) ###-#### then when you type a phone number in that cell like 1234567890 it should automatically format to (123) 456-7890. Hope this helps.
Answered by Carol on January 25, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP