Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is this cell protection?
I am working on a spreadsheet that has a ' at the beginning of each cell
containing a number. BUT you can only see the ' in the formula bar, not in the cell itself. What is this and how can I remove it??!!??!!? |
#2
|
|||
|
|||
Is this cell protection?
That apostrophe causing the number to be treated as a text string. If you
need to convert them all to numbers, I usually just put the number 0 in some random cell, copy it, then select the offending cells and Edit Paste Special, select Values and Add, then click OK --Bruce "DestinySky" wrote: I am working on a spreadsheet that has a ' at the beginning of each cell containing a number. BUT you can only see the ' in the formula bar, not in the cell itself. What is this and how can I remove it??!!??!!? |
#3
|
|||
|
|||
Is this cell protection?
Thank you thank you thank you!!! IT WORKED!!! :o)
"bpeltzer" wrote: That apostrophe causing the number to be treated as a text string. If you need to convert them all to numbers, I usually just put the number 0 in some random cell, copy it, then select the offending cells and Edit Paste Special, select Values and Add, then click OK --Bruce "DestinySky" wrote: I am working on a spreadsheet that has a ' at the beginning of each cell containing a number. BUT you can only see the ' in the formula bar, not in the cell itself. What is this and how can I remove it??!!??!!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Cell Protection Issue | Excel Worksheet Functions | |||
cell protection | Excel Discussion (Misc queries) | |||
Conditional formating - cell protection | Excel Discussion (Misc queries) |