As long as you let excel see those values as numbers, excel will always "treat"
them as the same number.

If you want 1.1 to be a different value than 1.10, you may want to force excel
to see them as text.

You can either start your data entry with an apostrophe: '1.10
or you can PRE-Format the cell as text (format|Cells|number tab), then do the
data entry.

ps. If you're doing this so that you can use it for an outline (maybe sort by
this field), don't use 1.1, use 1.01 (still text though).



Jock wrote:

How can I force Excel to recognise and display as different values 1.1 and
1.10? Formatting to two decimal places makes both 1.10 as does using the
general format.
--
tia

Jock

--

Dave Peterson