Thread: Convert numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARY GARY is offline
external usenet poster
 
Posts: 117
Default Convert numbers

When I tried Biff's suggestion: =A1*100 then formatted the cells as
CUSTOM and 000000000, the format would change to SPECIAL.

When I tried Ragdyer's suggestion: =TEXT(A1*100,"000000000"), the
format did not change and I got the results I needed.