View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noddyhawk Noddyhawk is offline
external usenet poster
 
Posts: 1
Default Convert decimals into mm in excel spreadsheet

I have a spread sheet with columns of inches shown in 3 decimals points. eg
3/4" is shown as 0.750. i wish to change these measurements into millimetres.
Can someone please give a step by step instruction guide for me?
I have tried "convert" function but cannot seem to get it to work correctly.
Thanks for your help.
Kind regards,
Noddyhawk.