software

I have a csv file that I converted to Excel. Some of the data came out as
text for example ' 2568.04. How could I convert these cells to numbers?

Thanks,Select an empty cell and copy it (ctrl c). Highlight the data you need
converted and Edit gt; Paste Special, select Add and click OK. (Adding 0
forces Excel to perform the conversion from text to number).

quot;Anatquot; wrote:

gt; I have a csv file that I converted to Excel. Some of the data came out as
gt; text for example ' 2568.04. How could I convert these cells to numbers?
gt;
gt; Thanks,
gt;

bpeltzer - it didn't work

quot;bpeltzerquot; wrote:

gt; Select an empty cell and copy it (ctrl c). Highlight the data you need
gt; converted and Edit gt; Paste Special, select Add and click OK. (Adding 0
gt; forces Excel to perform the conversion from text to number).
gt;
gt; quot;Anatquot; wrote:
gt;
gt; gt; I have a csv file that I converted to Excel. Some of the data came out as
gt; gt; text for example ' 2568.04. How could I convert these cells to numbers?
gt; gt;
gt; gt; Thanks,
gt; gt;

Try replacing the single quote with nothing.
--
Kevin Vaughnquot;Anatquot; wrote:

gt; I have a csv file that I converted to Excel. Some of the data came out as
gt; text for example ' 2568.04. How could I convert these cells to numbers?
gt;
gt; Thanks,
gt;

Hmmm, haven't seen that not work.
Suppose your data starts in cell B2. In a blank cell of that row, enter the
formula =value(b2). Autofill the formula down through the entire table.
Select that column, copy (ctrl c) and Edit gt; Paste Special, select Values
and Paste. That column should now have all your numbers.

quot;Anatquot; wrote:

gt; bpeltzer - it didn't work
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; Select an empty cell and copy it (ctrl c). Highlight the data you need
gt; gt; converted and Edit gt; Paste Special, select Add and click OK. (Adding 0
gt; gt; forces Excel to perform the conversion from text to number).
gt; gt;
gt; gt; quot;Anatquot; wrote:
gt; gt;
gt; gt; gt; I have a csv file that I converted to Excel. Some of the data came out as
gt; gt; gt; text for example ' 2568.04. How could I convert these cells to numbers?
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt;

Sorry for the long delay -busy with work. It seems like it doesn't work with
csv files. But the text to colum works.

Thank you both.

Anat
quot;Kevin Vaughnquot; wrote:

gt; Try replacing the single quote with nothing.
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;Anatquot; wrote:
gt;
gt; gt; I have a csv file that I converted to Excel. Some of the data came out as
gt; gt; text for example ' 2568.04. How could I convert these cells to numbers?
gt; gt;
gt; gt; Thanks,
gt; gt;