Microsoft KB Archive/62726

{| = Converting a Specialized Number Format with RIGHT in Excel =
 * width="100%"|

Last reviewed: November 4, 1994

Article ID: Q62726

SUMMARY
Formulas that contain special codes that, for example, determine the number of trailing zeros in a numeric value can be converted to real numbers with the RIGHT or LEFT Excel function.

An example of one type of specialized format that has been used is a several-digit number, where the first digit represents the number of zeros that follow the other digits. The cell A1 may contain a number such as 6380. The first digit, 6, indicates the number of zeros after the remaining digits, 380. Thus 6380 actually represents the value 380,000,000.

To convert the number format of 6380 to 380,000,000, use the following formula:

=VALUE(RIGHT(A1,3))*10^VALUE(LEFT(A1,1))
 * }