Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

=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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Format <=Today()	Matt D Francis	Excel Worksheet Functions	0	March 28th 07 02:46 AM
Conditional Format <=Today()	Marcelo	Excel Worksheet Functions	0	March 28th 07 02:45 AM
MM/DD/YYYY format Today	Glenda	Excel Discussion (Misc queries)	1	February 21st 06 03:51 PM
Format Today function	Grant	Excel Programming	2	November 8th 04 09:25 PM
converting 'TODAY' into dd-mmm-yy format	neowok[_24_]	Excel Programming	3	February 27th 04 12:40 PM

All times are GMT +1. The time now is 03:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us