Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Default cell format in Excel

Why would Excel default to a display of (example) 0.03 when the number 3 is
entered in a cell? When the Format Cells dialog box is opened, the format
shows as General. This happens on every new and existing workbook on a
particular PC. Could there be a setting somewhere or is it a fault in the
program?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Default cell format in Excel

Correct the setting at:

<Tools <Options <Edit tab,
And *Uncheck*
"Fixed Decimal Places".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"kat0301" wrote in message
...
Why would Excel default to a display of (example) 0.03 when the number 3 is
entered in a cell? When the Format Cells dialog box is opened, the format
shows as General. This happens on every new and existing workbook on a
particular PC. Could there be a setting somewhere or is it a fault in the
program?


Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to apply same format of referenced cell in Excel Steven Brassem Excel Discussion (Misc queries) 0 September 21st 06 01:14 PM
cell format for date/time in same cell excel 2003 Sandy Excel Worksheet Functions 1 January 18th 06 03:46 AM
How do I set Excel cell format to "Text" from VB.NET? John Brock Excel Discussion (Misc queries) 8 July 26th 05 04:36 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 01:57 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"