Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Apostrophe at the start of a cell | Excel Discussion (Misc queries) | |||
What is the 'Apostrophe' before Excel cell data for? | Excel Discussion (Misc queries) | |||
Apostrophe In Every Cell | Excel Discussion (Misc queries) | |||
iNSERT LEADING APOSTROPHE | Excel Discussion (Misc queries) | |||
Cell has an apostrophe and is text | Excel Discussion (Misc queries) |