Varying format

[IC]

Is there any way to format a cell differently depending on the number of
decimal places typed in? What I need is a minimum of 2dp but 3 if the typed
entry matches. eg 1.2 appears as 1.20 and 1.234 appears as typed.

TIA

Ian

 

[AlfD]

Hi!

Try formatting the cell with a custom number format such as 0.00##

Al

 

[IC]

Try formatting the cell with a custom number format such as 0.00##

Alf

Perfect! Thanks Alf