2006-07-29 21:20:35 · 4 answers · asked by Anonymous in Business & Finance ➔ Advertising & Marketing
on the tool bar your see a button to increase/ decrease decimal points. It's got a arrow with zero's next to it.
2006-07-29 21:25:55 · answer #1 · answered by Anonymous · 0⤊ 0⤋
The other answers are OK but if you want to round to a specific price point then you need to set up a formula that says if range<£54 and >£48 then cell = £49 or the like.
It should be easy enough.
2006-07-30 06:14:53 · answer #2 · answered by nkellingley@btinternet.com 5 · 0⤊ 0⤋
I think i need to lie down, lucky hedgehog rules.
Format - cells - number - currency - decimal places - 0
mg
2006-07-30 04:41:29 · answer #3 · answered by Mark G 2 · 0⤊ 0⤋
what do you mean? like this one:
52.894945.1141.2237.3333.4429.5525.6621.7717.8813.99
then apply your currency symbol by formatting cell...
or how many pointing reference do you want between 52.89 to 49?
2006-07-30 04:30:16 · answer #4 · answered by aRnObIe 4 · 0⤊ 0⤋