Home |
Search |
Today's Posts |
#1
|
|||
|
|||
1 is converted in 0.001 in all excell files
in my all exell files: old and new: when i put any numeric value and press
enter it is displayed in fraction . For eg. 1 is dispalyed as 0.001 I want to remove this coversion but dont know hoe. |
#2
|
|||
|
|||
Click Tools Options Edit tab
Uncheck "Fixed decimal" OK (It's probably checked for 3 d.p.) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "ndn" wrote in message ... in my all exell files: old and new: when i put any numeric value and press enter it is displayed in fraction . For eg. 1 is dispalyed as 0.001 I want to remove this coversion but dont know hoe. |
#3
|
|||
|
|||
see response to previous question.
-- HTH RP (remove nothere from the email address if mailing direct) "ndn" wrote in message ... in my all exell files: old and new: when i put any numeric value and press enter it is displayed in fraction . For eg. 1 is dispalyed as 0.001 I want to remove this coversion but dont know hoe. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
Excell Files attached to emails are suddenly not readable today. . | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) |