LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Apostrophe problem

Hello,

I am working with a spreadhseet and the data looks normal, however
when you click on the cell the data value contains a leading
apostrophe.

for example the data looks like this:

'4
'8
'10
'8


IS there a quick and easy way to get rid of the leading " ' "? If
so, an advice on how to do this would be greatly appreciated!

 
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
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel [email protected] Excel Discussion (Misc queries) 2 July 13th 06 01:55 PM
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel [email protected] Excel Programming 2 July 13th 06 01:55 PM
Double Quote Leading to Apostrophe Problem ToferKing Excel Programming 4 January 27th 06 03:41 PM
Add apostrophe Tony Wainwright Excel Worksheet Functions 4 October 29th 04 01:50 PM
Add apostrophe Tony Wainwright[_2_] Excel Programming 4 October 29th 04 01:50 PM


All times are GMT +1. The time now is 12:46 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"