Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to enter a formula is there and way for me to enter 4.79*10^6?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Entering formulas containing quotation marks in VBA? | Excel Discussion (Misc queries) | |||
Entering Formulas | Excel Worksheet Functions | |||
Entering formulas | Excel Worksheet Functions | |||
entering formulas | Excel Worksheet Functions | |||
entering formulas in Excel | Excel Worksheet Functions |