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.
|