Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Programming | |||
Double Quote Leading to Apostrophe Problem | Excel Programming | |||
Add apostrophe | Excel Worksheet Functions | |||
Add apostrophe | Excel Programming |