Custom Number Format

[bhenlee]

Hi Experts,

Is there a way to custom format a cell to show this number format: 0000.00.00 or 0000.00.0000

There should always be 4 digits before the 1st period then 2 before the 2nd.. the digits after the 2nd period could be either 2 or 4 digits long..

Thank you

[José Augusto]

Try this format
[<=99999999]0000\.00\.00;0000\.00\.0000

See if the ; do not work try ,

[bhenlee]

That worked. Thank you Jose Augusto!!!

[José Augusto]

You are welcome.

Regards