Brilliant Thanks for your help
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-7592F5.10560911052005@msnews.microsoft.com...
> one way:
>
> Format/Cells/Number/Custom 0"mm"
>
>
> In article <42823795$0$569$ed2619ec@ptn-nntp-reader03.plus.net>,
> "Amanda Cooper" <amandac@critical-skills.co.uk> wrote:
>
> > Just wondered if anyone new if you could have a format in excel that
shows
> > millimetres in a cell?