View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Format cell - Miles

Hi

Format the cells as Custom In the "Type:" field enter:

# "Miles"

finish with OK.

Hopes this helps.
....
Per

"Dave Eade" skrev i meddelelsen
...
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