vegasbound365
New Member
- Joined
- Jul 7, 2004
- Messages
- 41
I pasted some data, including dollar amounts, from an e-mail into Excel 2003. After I performed a text to column function, the dollar amounts are still treated as text and I cannot subtotal anything.
I tried to change the format of the cells, but that doesn't work.
I went into Tools/Options/Error Checking/and made sure the "text to numbers box" is checked and the "enable background error checking box" is checked, but still nothing.
Any advice?
I tried to change the format of the cells, but that doesn't work.
I went into Tools/Options/Error Checking/and made sure the "text to numbers box" is checked and the "enable background error checking box" is checked, but still nothing.
Any advice?