ExcelBanter - =TODAY() + 1 format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - =TODAY() + 1 format (https://www.excelbanter.com/excel-programming/324990-%3Dtoday-1-format.html)

AYPCN

=TODAY() + 1 format

=TODAY() + 1 format
i would like the date to be to show is 031005

how can i do thsi format

thanx,
Paul M.

Bob Phillips[_6_]

=TODAY() + 1 format

Format the cell as mmddyy

--

HTH

RP
(remove nothere from the email address if mailing direct)

"AYPCN" wrote in message
...
=TODAY() + 1 format
i would like the date to be to show is 031005

how can i do thsi format

thanx,
Paul M.

Ron Rosenfeld

=TODAY() + 1 format

On Wed, 9 Mar 2005 12:35:05 -0800, "AYPCN"
wrote:

=TODAY() + 1 format
i would like the date to be to show is 031005

how can i do thsi format

thanx,
Paul M.

Format/Cells/Number/Custom Type: mmddyy

--ron

All times are GMT +1. The time now is 05:33 AM.