Cell Formatting

**nathanB** · 12-14-2012, 06:21 AM

Hi all,

Quick question regarding cell formatting. I want a cell to appear "05 Years, 10 Months, 22 Days" with the cells format. How would I put that into a format code?

Thanks

**martindwilson** · 12-14-2012, 06:31 AM

so what would you be putting in the cell?

**nathanB** · 12-14-2012, 07:07 AM

Sorry for the late reply. My colleague has shown me how to do this in work.

Thank you for the help though

**Kevin UK** · 12-14-2012, 07:50 AM

Hi

Perhaps it might be worth sharing, since you did ask the question.
Others might come here looking for the same thing!

Kevin

**nathanB** · 12-14-2012, 07:56 AM

Originally Posted by Kevin UK

Hi

Perhaps it might be worth sharing, since you did ask the question.
Others might come here looking for the same thing!

Kevin

Of course. Turned out to be extremely simple. I wasn't putting in the commas in the quotation marks resulting in it not recognizing it and producing an error.

The formula is

dd "Days," mm "Months," yy "Years"

resulting in

05 Days, 12 Months, 11 Years

Hope this helps those who need it!