convert text to dollar
I don't understand what you mean by "dollar amount" but it looks like you can
just divide the number by 100. To do that for a range of cells follow this
procedure.
1. Enter 100 in a blank cell
2. Copy the cell
3. Select the range you want to divide by 100
4. Right Click and select "paste special"
5. Select "values" and "divide" and click ok.
"julz" wrote:
How do I convert a text number to dollar amount ?
Example :
711 to 7.11
17263 to 172.63
|