| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get 18 numbers to display in a column and not round out
I need a column to display 18 numbers and currently it is rounding the last
three with zeros. I am using Microsoft 2003 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get 18 numbers to display in a column and not round out
How many digits in the numbers
More than 15? Then you will need to type then as text and will not be able to do math on them Either a) when typing, precede the entry with a single quote (will not show in cell or printout b) before typing, format cells as Text best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters "whamm24" wrote in message ... I need a column to display 18 numbers and currently it is rounding the last three with zeros. I am using Microsoft 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column headings display as a numbers | Excel Discussion (Misc queries) | |||
| how do I round a column of numbers to the nearest | Excel Worksheet Functions | |||
| Round a whole column of numbers | Excel Discussion (Misc queries) | |||
| Can you format a whole column of numbers to round? | Excel Worksheet Functions | |||
| Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) | |||
Linear Mode
