Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formulas / formatting
This has come up on an excel spreadsheet. How do I change this into a number?
1.00311E+14. |
#2
|
|||
|
|||
Jazzy1980 wrote:
This has come up on an excel spreadsheet. How do I change this into a number? 1.00311E+14. That is a number, equal to 1.00311 with the decimal point moved to the right by 14 places. You can format it as a fixed point number if you wish by selecting it's cell and clicking on FormatCells. Then tell it to use "number" format rather than "scientific". It will probably just show you a bunch of ##### which means that your column isn't wide enough to display so large a number. Generally speaking, if you have such a large number it's easier to understand it with scientific notation than with fixed point. Bill |
#3
|
|||
|
|||
What is the number supposed to be? That is the real question. In my
experience, it looks like a date. Do as Bill Martin wrote and format as a date, if it supposed to be date. -- Top Notch Admin "Jazzy1980" wrote: This has come up on an excel spreadsheet. How do I change this into a number? 1.00311E+14. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Excel error - remove some formatting | Excel Discussion (Misc queries) | |||
Excel Formulas and formatting | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions |