TransWikia.com

Why doesn't "Custom number format" show up in Google Sheets (Google Spreadsheets)?

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.

  1. Highlight the data you want to format.
  2. Click the Format menu and hover over “Number” (or click the 123 number format icon in the toolbar).
  3. Select Custom number format….
  4. Search in the menu text box to select a format. You can also add your own custom number format into the text box.
  5. Click Apply.

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.

number formatting options

2 Answers

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP