Remember Me?

#1
July 21st 08, 01:54 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2008 Posts: 1
Decimal points data not displaying as expected

When entering the following number in Excel it doesn't display correctly
either in the cell or the formula bar -

Cell is formatted as Number with 9 decimal points.

I enter this number: 287488758463.904876
Cell displays: 287488758463.905000000
Formula Bar displays: 287488758463.905

How can I get it to display exactly what is typed into the cell?

#2
July 21st 08, 02:04 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,907
Decimal points data not displaying as expected

Excel has a 15 digit limit on numeric precision.

Preface the entry with an apostrophe.

You won't be able to do calculations but your data will be displayed as you
wish.

For more on Excel limits etc. se help on "specifications"

Gord Dibben MS Excel MVP

On Sun, 20 Jul 2008 17:54:15 -0700, g. spence
wrote:

When entering the following number in Excel it doesn't display correctly
either in the cell or the formula bar -

Cell is formatted as Number with 9 decimal points.

I enter this number: 287488758463.904876
Cell displays: 287488758463.905000000
Formula Bar displays: 287488758463.905

How can I get it to display exactly what is typed into the cell?

#3
July 21st 08, 02:15 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 62
Decimal points data not displaying as expected

By using an apostrophe, the cell data goes from being a number to a
string, therefore in order to use the cell for caculations, you must
revert the cell information back to a number from the string
afterwards. In VBA this is done by using val(string).

On 7\$B7n(B21\$BF|(B, \$B8aA0(B10:04, Gord Dibben <gorddibbATshawDOTca wrote:
Excel has a 15 digit limit on numeric precision.

Preface the entry with an apostrophe.

You won't be able to do calculations but your data will be displayed as you
wish.

For more on Excel limits etc. se help on "specifications"

Gord Dibben MS Excel MVP

On Sun, 20 Jul 2008 17:54:15 -0700, g. spence

wrote:
When entering the following number in Excel it doesn't display correctly
either in the cell or the formula bar -

Cell is formatted as Number with 9 decimal points.

I enter this number: 287488758463.904876
Cell displays: 287488758463.905000000
Formula Bar displays: 287488758463.905

How can I get it to display exactly what is typed into the cell?- \$B0zMQ%F%-%9%H\$rI=<(\$7\$J\$\$(B -

- \$B0zMQ%F%-%9%H\$rI=<((B -

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Peteylepieu Excel Discussion (Misc queries) 1 October 2nd 07 10:18 PM Don Burgess Charts and Charting in Excel 3 November 28th 06 06:20 PM notloiseweiss Excel Discussion (Misc queries) 3 November 11th 05 10:17 PM Brenda Charts and Charting in Excel 3 October 27th 05 04:10 AM Leanne Excel Worksheet Functions 1 June 28th 05 02:30 AM

All times are GMT +1. The time now is 08:42 AM.