Skip4t4

Posts: n/a

Dates to number in edit line

In cell A:1 I have 15/05/1974 which is formatted as 19740515

I want to see 19740515 in the edit line as I need to create a csv with
19740515 and not 27164

Any ideas?

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
Determining the number of specific days between two dates in Excel	jon s	Excel Worksheet Functions	9	March 21st 05 09:13 PM
Count the number of dates in a range that are earlier than today.	DeborahS	Excel Worksheet Functions	1	March 9th 05 01:54 AM
Where is DateDiff function in Excel 2002 ?	Nigel Welch	Excel Worksheet Functions	4	March 4th 05 03:18 PM
Find number of days between to dates	Qaspec	Excel Worksheet Functions	1	January 21st 05 12:14 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 05:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us