View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott_mitchell_roaming scott_mitchell_roaming is offline
external usenet poster
 
Posts: 1
Default How do I format numbers in engineering units (e.g. m, u, n)

How do I format my data to display in engineering units. For example if a
cell had a value of 0.000015 it is displayed as 15n and if it was 0.022 it
displays as 22m and for 34000 it displays as 34k. It must be possible to do
this but I cannot fnd it in help.