or how can this be solved by having the input and output on the same row. custom format code solved this for numbers — Modify value of a cell using the old value as part of the new one?
quotes:
"…you can use commas after the number format to display the number divided by multiples of 1000. For example, #,##0.000, displays a value divided by one thousand and #,##0.000000,, displays the number divided by one million."
but it doesnt seem to work for percents.
the input are percents, like 20%, which would be .20, the output is those percents in decimal form being multiple by 1000
couldnt find anything on http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx
Best Answer
To achieve this, just select custom format as
Percentage
OR
On custom format, use this
0.00%
Here B column's:
=A1/1000
and0.00%
the 200 or the result it was suppose to be did not come up with this custom format