A
Anne Rachuy
Hello:
I received a spreadsheet from a client with hundreds of rows of dollar
amounts. The cell that have a figure that is 1.00 or greater have no
problems, but the cells that have a dollar amount from 0.01 to 0.99 show up
in the cell as ="0.25" instead of 0.25. This is obviously causing a problem
when attempting to add up the a series of rows since "0.25" is a label, not
a number. My question is how can I easily convert ="0.25" to 0.25 without
going through cell by cell and re-entering the number? This spreadsheet has
over 15,000 cells with dollar amounts and I definitely don't want to go
through each one cell by cell. I've attempted to reformat the cells, but
that has no impact on it.
If anyone has any ideas, I would really appreciate the help.
Thanks,
Mike
I received a spreadsheet from a client with hundreds of rows of dollar
amounts. The cell that have a figure that is 1.00 or greater have no
problems, but the cells that have a dollar amount from 0.01 to 0.99 show up
in the cell as ="0.25" instead of 0.25. This is obviously causing a problem
when attempting to add up the a series of rows since "0.25" is a label, not
a number. My question is how can I easily convert ="0.25" to 0.25 without
going through cell by cell and re-entering the number? This spreadsheet has
over 15,000 cells with dollar amounts and I definitely don't want to go
through each one cell by cell. I've attempted to reformat the cells, but
that has no impact on it.
If anyone has any ideas, I would really appreciate the help.
Thanks,
Mike