在Google表格中显示Lakhs和Crores [英] Displaying Lakhs and Crores in Google Sheets

问题描述

我希望使用Google表格提供方便的全球访问，但我确实需要以Lakh和Crore（印度风格）格式显示数字，以避免管理员混淆。

150,000 应显示为 1,50,000 和 12,000,000 应显示为 1,20,00,000 。

我尝试将格式设置为 ##，##，##，000 但我的号码仍显示为 12,000,000 。 文档中找不到任何内容。

有谁知道一种方法来完成这项工作吗？

解决方案

确实可以在Google表格中使用。

选择适当的单元格后，导航至：

  Google表格：格式 - >数字 - >更多格式 - >自定义数字格式
 Excel：正式 - >细胞 - >自定义 - > [自定义文本框] 
  

输入以下内容之一并应用：

Lakhs and Crores with symbol with decimals

  [$₹] [> 9999999]＃ ＃\，## \，## \，## 0.00; [$₹] [> 99999] ## \，## \，## 0.00; [$₹] ##，## 0.00 
  

B] Lakhs and Crores with symbol without decimals

  [$₹] [> 9999999] ## \，## \，## \，## 0; [$₹] [> 99999] ## \，## \，## 0; [$₹] ##，## 0 
  

没有带小数的符号的Lakhs和Crores

  [> 9999999] ## \，## \ ，###，## 0.00; [> 99999] ## \, ###\\, ## 0.00; ##，## 0.00 
  

D] Lakhs and Crores without symbol without decimals

  [> 9999999] ## \，## \，## \，## 0; [> 99999] ## \，## \，## 0; ##，## 0 
  

编辑：我已经在Google表格和Excel上测试了这些内容。负数可以工作

I would like to use Google Sheets for its convenient global access, but I really need to display numbers in Lakh and Crore (Indian style) format to avoid confusion among managers.

150,000 should display as 1,50,000 and 12,000,000 should display as 1,20,00,000.

I tried setting the format to ##,##,##,000 but my number still displays as 12,000,000. I couldn't find anything in the docs.

Does anyone know of a way to accomplish this?

解决方案

This works in Google Sheets for sure. Should work in Excel too.

With the appropriate cells selected, navigate to:

Google Sheets : Format -> Number -> More Formats -> Custom Number Format
Excel : Formal -> Cells -> Custom -> [Custom text box]

Enter one of the following and Apply:

A] Lakhs and Crores with symbol with decimals

[$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00

B] Lakhs and Crores with symbol without decimals

[$₹][>9999999]##\,##\,##\,##0;[$₹][>99999]##\,##\,##0;[$₹]##,##0

C] Lakhs and Crores without symbol with decimals

[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

D] Lakhs and Crores without symbol without decimals

[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0

Edit : I've tested these on both Google Sheets and Excel. Negative numbers work

这篇关于在Google表格中显示Lakhs和Crores的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！