Posted to microsoft.public.excel.misc

CM4@FL[_2_] CM4@FL[_2_] is offline

external usenet poster

Posts: 12

Date to text/number Conversion

Using today's date for example: =today() = 11/10/2009

Is it possible to convert the date to text shown as 11-10-2009?

Without typing it in as '11-10-2009

Thanks in Advance

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
Text to number conversion with trailing -	wynand	Excel Discussion (Misc queries)	2	November 4th 09 11:52 PM
Issue with Number Conversion to text	Yuvaraj Mani	Excel Worksheet Functions	0	October 15th 09 04:48 PM
Date to number conversion	Byron720	Excel Discussion (Misc queries)	2	June 23rd 08 09:29 PM
stop number to date conversion	jeffrey	Setting up and Configuration of Excel	2	April 26th 08 08:50 PM
Text to Number conversion	ALLYANA	New Users to Excel	6	October 16th 06 03:33 PM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us