JE,

With 0.???? an tnteger will diisplayed as e.g. 3. or 78. How for an integer
(only with integers) to get rid of the decimal point and keeping the LSD in
its place as if the decimal point also was in its place?
So we would get
3
0.1245
7.8
with the 3 right above the 0. But 3.00001 shopuld be displayed as
3.0000
Is that possible?

Jack Sons
The Netherlands

"JE McGimpsey" schreef in bericht
...
See "About custom number formats" in XL Help.

For instance:

Format/Cells/Number/Custom 0.0???

will display at least 1 but no more than 4 places after the decimal
point, aligned.


In article ,
"lynn" wrote: