ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Entering Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/153453-entering-formulas.html)

Rey

Entering Formulas
 
I am trying to enter a formula is there and way for me to enter 4.79*10^6?


Rey

Entering Formulas
 
I am trying to enter a formula is there any other way to enter 4.79*10^6
other than what I just posted?

John Bundy

Entering Formulas
 
Just put an = in front of it. Adjust as needed.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rey" wrote:

I am trying to enter a formula is there and way for me to enter 4.79*10^6?


Toppers

Entering Formulas
 
=4.79*10^6

"Rey" wrote:

I am trying to enter a formula is there and way for me to enter 4.79*10^6?


Sandy Mann

Entering Formulas
 
Do you mean:

=4.79*POWER(10,6)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rey" wrote in message
...
I am trying to enter a formula is there any other way to enter 4.79*10^6
other than what I just posted?




Dave Peterson

Entering Formulas
 
or without the formula:

4.79E6

You may want to apply a different format (maybe General instead of Scientific)
to the cell.



Rey wrote:

I am trying to enter a formula is there and way for me to enter 4.79*10^6?


--

Dave Peterson


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com