LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Insert apostrophe in each cell

Hi

I cannot see anywhere in your previous postings that you have said you have
done that.
You said you had formatted the column as Text. That is not at all the same
as what I told you to do.
Try doing what I said - you might get a nice surprise<g
--
Regards
Roger Govier

"Shari" wrote in message
...
I have already done that as I stated before.

That will not work.

"Roger Govier" wrote:

Hi

Just select the column of NumbersDataText to ColumnsNextNextselect
column type as TextFinish
All of you numbers will be converted to text values ready for importing

--
Regards
Roger Govier

"Shari" wrote in message
...
I was told to put it in front of each entry.

Also, the other formulas I was given are not working.

"Ron Rosenfeld" wrote:

On Tue, 4 Mar 2008 07:08:02 -0800, Shari

wrote:

For exporting, I am trying to insert an apostrophe in each cell in
one
of my
columns that contains numbers. There are over 800 records, how do I
do
this
without having to go to each cell and do it manually?

Where do you want to insert the apostrophe? Beginning, end, middle,
third
character from the right ????
--ron



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 at the start of a cell Nic Excel Discussion (Misc queries) 2 November 27th 06 04:27 PM
What is the 'Apostrophe' before Excel cell data for? RabC Excel Discussion (Misc queries) 1 May 20th 06 02:29 PM
Apostrophe In Every Cell astrange Excel Discussion (Misc queries) 4 April 7th 06 04:59 PM
iNSERT LEADING APOSTROPHE uncreative Excel Discussion (Misc queries) 3 March 30th 06 12:57 AM
Cell has an apostrophe and is text Carole O Excel Discussion (Misc queries) 2 March 3rd 05 08:09 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"