Why does entering =+$418M in Google Sheets cause a #ERROR?

[ashakantasharma]

Hi everyone,


When I enter =+$418M in a Google Sheets cell, it returns a #ERROR. Why does this happen, and how can I properly input or format large currency values like $418M without errors?


Thanks in advance for your help!

 

[vletm]

Did You notice that
... You asked in Ask an Excel Question something else than Excel-question?

As written in a header:
Chandoo.org Excel Forums - Become Awesome in Excel

Have You tried to 'Google' it?
or
Do same with Excel?

 

[vletm]

ashakantasharma​

Moderator Note:
Every Forum has same kind of rules.
Please, reread and follow Forum's rules.

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

K

Thread 'Site Rules - New Users - Please Read'

Feb 18, 2010

Hi all,

Welcome to the Chandoo.org Forums.

Posting Rules & Etiquette

The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge.

The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in.

Please take a few minutes to read this list of Rules, Procedures and Etiquette's for posting here at the Chandoo.org Forums.

How to get the Best Results at Chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches...

• keymaster
• Replies: 0
• Forum: Ask an Excel Question

•