#1   Report Post  
Posted to microsoft.public.excel.misc
Rey Rey is offline
external usenet poster
 
Posts: 5
Default Entering Formulas

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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Rey Rey is offline
external usenet poster
 
Posts: 5
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 772
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,345
Default 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?





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering formulas containing quotation marks in VBA? Gaetan Excel Discussion (Misc queries) 1 February 21st 07 08:24 PM
Entering Formulas Nickydad Excel Worksheet Functions 2 September 20th 06 02:12 AM
Entering formulas Nickydad Excel Worksheet Functions 1 September 20th 06 12:11 AM
entering formulas Tara Martin Excel Worksheet Functions 1 April 6th 06 07:33 PM
entering formulas in Excel deerhunter98 Excel Worksheet Functions 1 March 8th 06 01:35 AM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"