Hi,
use this custom format

0"."00"."00

if this helps please click yes thanks

"jvs" wrote:

I can format the date to display this way if we enter it as a date (e.g.
8/4/2009) etc.

Is there a way to enter 20090831 (no punctuation) and still have it display
as 2009.08.31?

I've tried custom format ####.##.## - it comes out as 20090831..