Mestrella31

Posts: n/a

Date Format Questions

how do I get this
=((DATE(2005,12,30))&" YTD")

to look like this

Dec 05 YTD

Right now I have a Cell that look like : 38716 YTD

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
Format date dd.mm.yyyy to dd/mm/yyyy	Kiwi User	Excel Discussion (Misc queries)	7	May 7th 23 11:44 AM
USING THE DATE FORMAT IN EXCEL	teach	Excel Discussion (Misc queries)	3	December 14th 04 11:55 PM
Date format collapses diagram	Richard H	Excel Discussion (Misc queries)	3	December 14th 04 11:08 PM
prevent 4/5 in a cell automatically transfer to a date format	kei	Excel Discussion (Misc queries)	3	December 9th 04 11:52 AM
Problem with Date format from VBA code	twig	Excel Discussion (Misc queries)	3	December 7th 04 06:01 PM

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

About Us

"It's about Microsoft Excel"