Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always enter number as a decimal <1
I want to be able to enter an integer into a cell and have it
automatically displayed and perceived by excel as a decimal less than 1. In other words, if I enter "456" into the cell, I want it to display as ".456" all the time. I would further like this formatting to apply to any number entered in that cell, regardless of how many sig figs there are, AND I only want it to apply to one cell or a specific range, so the Tools--Options--Edit--Fixed Decimal Places setting won't help me. If possible, I'd like to do this without a macro so it can be used with Pocket Excel. Thanks to all. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot a change a number 10.0 to 10 , cannot take out the decimal | Excel Discussion (Misc queries) | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions | |||
number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
How do I enter a prefix number to a colum of numbers | Excel Worksheet Functions |