View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Luke Moraga Luke Moraga is offline
external usenet poster
 
Posts: 14
Default Ten to the power of six

I'm not exactly sure what format you're wanting, so here's several.

If your wanting to display "10^6" exactly liek that, and you don't need it
for a calculation, try putting an apostrophe in front of it to tell Excel
that you want to display exactly as you write.

'10^6

If you need to use in calculation, try formatting the cell to scientific.
YOu can then set how many decimal places you want.

Hope this helps!

--
Best Regards,

Luke Moraga


"Corren" wrote:

WinXP, Excel 2007
I am unable to show this number in a cell. How do I do it?
Thank you.