How do I get 18 numbers to display in a column and not round out

's Computer Specifications

I need a column to display 18 numbers and currently it is rounding the last
three with zeros. I am using Microsoft 2003

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:69EEA822-B8CA-46F9-A93C-(E-Mail Removed)...
> I need a column to display 18 numbers and currently it is rounding the
> last
> three with zeros. I am using Microsoft 2003

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I round a column of numbers to the nearest	Suzy	Microsoft Excel Worksheet Functions	3	12th Nov 2008 09:49 PM
Round a whole column of numbers	=?Utf-8?B?RGFiYmxlcw==?=	Microsoft Excel Misc	3	1st Aug 2007 08:52 AM
Can you format a whole column of numbers to round?	=?Utf-8?B?ZGF3bg==?=	Microsoft Excel Worksheet Functions	4	9th Jun 2005 07:31 PM
Can you round numbers to display a specific set of numbers, for e.	=?Utf-8?B?bGJmcmllcw==?=	Microsoft Excel Misc	3	20th Apr 2005 09:52 PM
Create function to round all numbers in a column	Marianne	Microsoft Excel Worksheet Functions	2	29th Jun 2004 01:06 PM