View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Always enter number as a decimal <1

The solution provided allows for a variable number of digits

12==0.12
1234=0.1234
1234567=0.1234567

You can leave cell formatted as general but make wide enough to take largets
number

"michaelberrier" wrote:


Having said that, I just realized that this is a simple math formula
that needs to be divided by a different factor of ten based on how many
digits I want to use...duh.

So...I guess there isn't a solution that will allow the number of
digits to be variable?

Thanks again!