"Ron Rosenfeld" wrote in message
...
However, if you want it to display that way if you type in a 10, or a
number
less than 10, try this:

Format/Cells/Number/Custom Type: [<=10]"<10.00";0.00


Or if the OP wants to use the number as a number then perhaps:

[<=10]"< "#.00;0.00

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk