Format cell - Miles
Right clickFormat CellCustomType:
0 "Miles"
If this post helps click Yes
---------------
Jacob Skaria
"Dave Eade" wrote:
Hi, is there anyway to format a set of cells so that when I input a value,
say 308, the cell displays "308 Miles".
What I want is a bit like the currency fomat which changes 308 into £3.08.
Thanks
|