deleting the apostrophe
 

Hello:

In a column of Excel cells, I have the following character mask:

0000-0000-000-000-

The first character has an apostrophe in front of it. I want to create a
column to the right that has these characters and in the above format but
without the apostrophe that appears at the beginning.

What formula can I use to accomplish this?

Thanks!

childofhte1980s

deleting the apostrophe
 

Activecell.offset(0,1).Value = "0000-0000-000-000-"

--
Regards,
Tom Ogilvy

"childothe1980s" wrote in message
...
Hello:

In a column of Excel cells, I have the following character mask:

0000-0000-000-000-

The first character has an apostrophe in front of it. I want to create a
column to the right that has these characters and in the above format but
without the apostrophe that appears at the beginning.

What formula can I use to accomplish this?

Thanks!

childofhte1980s

deleting the apostrophe
 

The apostrophe is a special character that turns the cell into Text.
You can convert it back to a number by using =value(A1). You will los
the number formatting, but you can re-apply that with a custom format.

Mat

--
Mallyca
-----------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...fo&userid=3551
View this thread: http://www.excelforum.com/showthread.php?threadid=55305

deleting the apostrophe
 

The apostrophe has been added either by someone or when the data was
exported from another application and in Excel, it means the cell contents
is text. This will also include when a number is in the cell.

1. To remove it, in a blank cell type the number 0.
2. Now copy the cell with 0 in it.
3. Highlight the cells containing the apostrophe and Right Click on the
highlighted area
4. Now Paste Special.
5. Under the Operation part of the Paste Special Menu, select the "Add"
radio button and click OK.
6. The apostrophe has now gone.

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"childothe1980s" wrote in message
...
Hello:

In a column of Excel cells, I have the following character mask:

0000-0000-000-000-

The first character has an apostrophe in front of it. I want to create a
column to the right that has these characters and in the above format but
without the apostrophe that appears at the beginning.

What formula can I use to accomplish this?

Thanks!

childofhte1980s

deleting the apostrophe
 

Using =Value(A1)
gives me an error #Value


maybe, if a formula is required:
=TEXT(A1,"0000-0000-000-000-")





--
Regards,
Tom Ogilvy

"Mallycat" wrote in
message ...

The apostrophe is a special character that turns the cell into Text.
You can convert it back to a number by using =value(A1). You will lose
the number formatting, but you can re-apply that with a custom format.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553058