Spreadsheet question.

</p>

I'm putting unit values in a column and the row five box won't accept &pound;3.00 it just keeps reverting to &pound;3. What the ballocking chuff's up with it?</p>

 

format the cell or column to number and 2 dp. nt

 

right click the box

choose format cells from from the pop-up menu. Change decimal places to 2.

 

Thanks chaps. nt

 

A spreadsheet for 3 quid! Phhhffftt!

Is that thi Corporation Tax bill then Don?

 

doh **************************************************** nt

 

No, it isn't. And stop bullying me.

</p>

I've already told theeit's a unit value. I was going to ask how you make the unit quantities column wider but you just keep tapping the zero and it does it on its own.</p>

 

dohhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh nt