David Billigmeier

Posts: n/a

Tools-Options-Edit Tab-Uncheck "Fixed Decimal"
--
Regards,
Dave

"Bart" wrote:

if I type 1 it becomes 0.0001 , if I type 1.0 is becomes 1

Does anybofy know how to fix this?

Thanks

Bart

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Turn off automatic date formatting?	Nick Turner	Excel Discussion (Misc queries)	3	July 13th 06 08:13 AM
Enable Automatic Refresh	Terri	Excel Worksheet Functions	1	August 8th 05 11:26 PM
How can I find automatic links in an Excel-sheet?	Tobias	Excel Discussion (Misc queries)	4	August 4th 05 09:02 AM
find automatic page breaks	Reason	Excel Worksheet Functions	1	April 15th 05 06:03 AM
Automatic backup copy	craigq	Charts and Charting in Excel	2	April 11th 05 04:57 PM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us