LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 45
Default Numbers view different when clicked on cell

I have a data export that views correctly with numbers at two decimals
(12.56) but when I click on the cell - the number display with eight
decimals (12.561212230. i have tried changing the format globally but it
won't change. I can change them individually but was wondering what would
make this happen?

Jo


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How can I pop up a picture when a cell is clicked on Excel? Hamlet Excel Discussion (Misc queries) 2 August 29th 08 08:16 PM
How can I detect that an excel cell has been clicked Ballantine Excel Discussion (Misc queries) 5 August 14th 08 10:09 AM
HOW DO I GET AN X IN A CELL IN EXCEL TO COME & GO WHEN CLICKED carbetboy Excel Discussion (Misc queries) 3 March 22nd 08 11:21 PM
Is it possible to have phone numbers dial when clicked in Excel? artemis1027 Excel Worksheet Functions 1 June 28th 06 06:26 PM
unhide rows when cell is clicked lauren_roberts08 Excel Worksheet Functions 2 June 13th 06 08:54 PM


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"