Posted to microsoft.public.excel.misc

Quippian

external usenet poster

Posts: 1

Number of significant digits allowed in a cell is 15.

I need to enter a total of 16 significant digits in a cell. The problem that
I am experiencing is that the 16th digit always returns as the number "0". I
need to display the actual digit that is entered into that cell.

How can I accomplish this task?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
significant digits	Gordon[_2_]	Excel Worksheet Functions	20	October 1st 08 07:14 PM
how can I sum up the values with more than 15 significant digits?	mohammad	Excel Discussion (Misc queries)	5	October 25th 07 02:56 PM
maximum number size/significant digits	noel	Excel Discussion (Misc queries)	4	February 20th 06 03:42 PM
Significant digits	Marcus	Excel Worksheet Functions	5	November 16th 05 03:39 PM
return significant digits of a cell	Chace	Excel Worksheet Functions	2	October 1st 05 01:35 PM

All times are GMT +1. The time now is 09:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us