Custom format problem (SOLVED)

[phantom1975]

If I enter 1234 in a cell, I want it to show up as 12.34 AND I still want the value to be 1234, not 12.34. How do I set up the custom formatting to do this?

_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-09-20 15:50

 

[Mark W.]

00"."00

 

[phantom1975]

Right on. That works. What is the difference between 00"."00 and ##"."##?

 

[Mark W.]

# displays only significant digits and does not display insignificant zeros.

0 (zero) displays insignificant zeros if a number has fewer digits than there are zeros in the format.

? adds spaces for insignificant zeros on either side of the decimal point so that decimal points align when formatted with a fixed-width font, such as Courier New. You can also use ? for fractions that have varying numbers of digits.

 

[phantom1975]

So if I wanted to do a custom currency format, I would use:

##"."00