Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / April 2008

Tip: Looking for answers? Try searching our database.

Formatting Numbers no longer seems to work

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
James W - 22 Apr 2008 18:05 GMT
This morning I was trying to set up a very simple quotation for a customer
and I find that entering whole numbers no longer seems to be possible.
Let's take "25" since that was the first number I wanted to enter.
It displayed as 0.0025 instead of 25
When I format the cell to
"Number" then 0.00 is displayed
"Currency" then $0.00 is displayed
"Accounting" then $0.00 is displayed
Percentage then 0.25% is displayed
There's no way I can display the whole number "25" nor any other number. I'm
using Excel 2003 and have used previous editations of Excel since 1996.  
I removed Excel from Office and re-installed it, but that didn't help.
What has suddenly gone wrong?
Thanks for any help.

Signature

James

Max - 24 Apr 2008 00:00 GMT
Maybe it's just a fixed decimal setting
Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> This morning I was trying to set up a very simple quotation for a customer
> and I find that entering whole numbers no longer seems to be possible.
[quoted text clipped - 10 lines]
> What has suddenly gone wrong?
> Thanks for any help.
James W - 24 Apr 2008 01:47 GMT
That's all it took to fix it.

Thanks, Max.
Signature

James

> Maybe it's just a fixed decimal setting
> Click Tools > Options > Edit tab
[quoted text clipped - 13 lines]
> > What has suddenly gone wrong?
> > Thanks for any help.
Max - 24 Apr 2008 03:43 GMT
Glad it helped, James.
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> That's all it took to fix it.
>
> Thanks, Max.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.