Posted to microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions

Tony Wainwright[_2_] Tony Wainwright[_2_] is offline

external usenet poster

Posts: 1

Add apostrophe

Hi guys

I am writing an Access d/b that uses an Excel spreadsheet as it's data
source. The spreadsheet contains about 24,000 rows. I have noticed that in
some of the columns numbers are formatted with an apostrophe. I would like
to create a routine that searches through specified columns and adds an
apostrophe to the start of each entry, but I am not that familiar with
Excel. Does anyone know where I might find such a routine

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
Apostrophe in Numbers	rivkee	Excel Discussion (Misc queries)	5	November 14th 08 08:46 PM
Leading Apostrophe	[email protected]	Excel Worksheet Functions	3	September 10th 08 07:36 AM
Always have apostrophe	snax500	Excel Discussion (Misc queries)	5	June 22nd 07 08:26 PM
Delete apostrophe	Susana Conklin via OfficeKB.com	Excel Discussion (Misc queries)	2	December 3rd 04 08:15 PM
Add apostrophe	Tony Wainwright	Excel Worksheet Functions	4	October 29th 04 01:50 PM

All times are GMT +1. The time now is 12:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us