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

You can't do it with formatting.


"Niklas" wrote in message
...
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