Hi Jack

when i open a new workbook and type 1.1 in A1, and 1.22 in B1 it displays it
as i enter it - same if i then change the 1.1 to 1.22 and vice versa - still
only get what i entered ... so i'm not sure what you're really asking? Do
you want the 1.1 to change to 1.10 or ?????

Note, the format of these cells is "general" not "number" - no need to play
with the format / cells option unless you want a specific number of decimal
places all the time.


Cheers
JulieD


"Jack" wrote in message
...
I have scientif numeric data that is entered into cells on a monthly basis.
The data may change decimal places from month to month depending on what
the
reported lab value is. For example a lab report may read 1.1 for a
particular month and then 1.22 for another month. Is there a way to enter
this data freely without having to reformat the decimal places in a range
of
cells for these variations?
--
Thanks - Jack