Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find '
I have a program which creates an Excel file but places a " ' " at the
beginning of every cell, numbers included, for example { '18.75000 }. Reformatting the cells does not make the text a numeric. I can edit out the ' manually but using Find And Replace produces error message that data cannot be found. What am I missing? Thanks |
#2
|
|||
|
|||
Try this in Excel to for a possible fix:
Copy a blank cell. Select your numbers and choose Edit | Paste Special | Add. tj "noyb" wrote: I have a program which creates an Excel file but places a " ' " at the beginning of every cell, numbers included, for example { '18.75000 }. Reformatting the cells does not make the text a numeric. I can edit out the ' manually but using Find And Replace produces error message that data cannot be found. What am I missing? Thanks |
#3
|
|||
|
|||
Now why would that work? Its a mystery to me but ... thanks.
tjtjjtjt wrote: Try this in Excel to for a possible fix: Copy a blank cell. Select your numbers and choose Edit | Paste Special | Add. tj "noyb" wrote: I have a program which creates an Excel file but places a " ' " at the beginning of every cell, numbers included, for example { '18.75000 }. Reformatting the cells does not make the text a numeric. I can edit out the ' manually but using Find And Replace produces error message that data cannot be found. What am I missing? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Find & Replace results to display specified chosen fields | Excel Discussion (Misc queries) | |||
boolean find criteria in Excel | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |