Re: how does one convert text to a formula "average(A:A)" to =average(
- From: "Jason Morin" <jasonjmorin@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Apr 2005 17:17:26 -0700
Assuming your "formulas" w/out equal signs are in column
A...
1. Insert this into row 1 of an open col. (say col. B)
and fill down:
="="&A1
2. Select col. B, copy it, and go to Edit > Paste Special
> Value.
3. Press Ctrl+H and fill in:
Find What: =
Replace With: =
HTH
Jason
Atlanta, GA
>-----Original Message-----
>Would prefer not having to enter = manually in each cell.
>.
>
.
- References:
- Prev by Date: fixed decimals
- Next by Date: RE: excel moving average
- Previous by thread: Re: how does one convert text to a formula "average(A:A)" to =average(
- Next by thread: Re: how does one convert text to a formula "average(A:A)" to =average(
- Index(es):
Relevant Pages
|
