Intro: If I have a number such as 1,000,000 and apply the number format 0,, it displays as 1. Each comma in the number format shifts the decimal to the left 3 spaces for display purposes.

Now, let's say I have a number such as 0.000001 (one millionth or 1 ppm). Is there a number format code that I could apply that would display it as 1. Basically, I'm looking for a format operator that will do the exact opposite of the comma. Something that will shift the decimal to the right 3 places for each occurence. Am I lucky enough to have it built into Excel (2002 version)??