View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niklas
 
Posts: n/a
Default Costom format - 0.0061 to 6.1

Hi
If I want to scale a number by a multiple of one thousand in Custom Format I
write #,
Fo example 6000 will be displayed as 6.
Is it possible to do it the our way around. For Example I want the number
0.0061 to be displayed as 6.1. How do i do it?
Regards
/Niklas