Posted to microsoft.public.excel.worksheet.functions

Natalie

external usenet poster

Posts: 44

Date format problem

Hi all,

The dates in my column are preceded by and apostrophe. Anyone knows a quick
way to get rid of the apostrophe. I have about 3000 rows on the spreadsheet.

This is how the date appear

€˜ 04/05/2007

To get rid of it I back space or delete the apostrophe.

Thanks for your help!

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
Date Format Problem	Gayla	Excel Discussion (Misc queries)	3	April 18th 07 07:48 PM
Date Format - Formula Problem	Josh O.	Excel Discussion (Misc queries)	4	January 19th 07 06:36 PM
Date format problem	Vass	Excel Worksheet Functions	7	April 3rd 06 04:50 PM
Date Format problem	nastech	Excel Discussion (Misc queries)	2	January 18th 06 01:54 AM
date format problem	Nigel	Excel Discussion (Misc queries)	7	May 11th 05 12:57 PM

All times are GMT +1. The time now is 01:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us