Hi,

I have a load of formulae currently displayed as text. This is not a case
of converting using the 'Number' from the Category selection.

At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
to the ' then deleting it and hitting the Ente key. I dont fancy doing this
for a couple of hundred cells. Any solutions to this would be appreciated.

Thanks

John

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Hi John,

Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.

Hope this helps.

Pete

Niek Otten wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Enter and run this small macro:

Sub tic_killer()
For Each r In ActiveSheet.UsedRange
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub

(find/replace may not work)
--
Gary's Student


"John" wrote:

Hi,

I have a load of formulae currently displayed as text. This is not a case
of converting using the 'Number' from the Category selection.

At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
to the ' then deleting it and hitting the Ente key. I dont fancy doing this
for a couple of hundred cells. Any solutions to this would be appreciated.

Thanks

John

Hi Niek,

Nope. Edit Find and Replace wont work! Here's the formulae in the cell
=counta(H:\Work\[Cases_Older_Than_One_Year.xls]110107!$A:$A)-1
Before the = is ' If i hit F2 Home then Delete then Enter.

Any thoughts please?

Thanks

John


"Niek Otten" wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Hi Pete,

Well you learn something new everyday. Must remember that one.

Thanks

John


"Pete_UK" wrote:

Hi John,

Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.

Hope this helps.

Pete

Niek Otten wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Hi John,

thanks for feeding back.

I saw the tip on this forum several months ago - I think it was from
Rag Dyer.

Pete

John wrote:

Hi Pete,

Well you learn something new everyday. Must remember that one.

Thanks

John


"Pete_UK" wrote:

Hi John,

Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.

Hope this helps.

Pete

Niek Otten wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John