Thanks to David and Dom
--
tia

Jock


"Dom_Ciccone" wrote:

Only way I know of for this is to format the cell as Text. You can then
enter 1.1 and 1.10 and they will remain that way.

"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