EASY Excel question....making the cells 'normal' again?

[SideWinder]

Just filled in some cells but changed my mind about the colour. Now there are no 'borders'. I've tried a few options but i'm tired and need a quick solution. So how can i make the cells look like the rest again?

 

[asim18]

Styles > Normal.

 

[SideWinder]

Styles > Normal.

Didn't work...you do mean under the tab 'Border' and 'None' - not normal?

 

[asim18]

Hmm.... I assume you're using office 2003 then?

This is what I was talking about:


I'll try to find the same thing in 2003 for you.


EDIT: Select the cells, then click on Format > Style, and select "Normal" in the drop-down list and click OK.

 

[SideWinder]

Ahhhh, yeah got it. Cheers.

Any ideas how to make my 'Currency' show negative numbers? It is meant to show '-18.50' but it doesn't. It just shows '0.00'.

 

[asim18]

Is the cell formatted as currency?

I just tried that and it works, just type in "-18.50" and it will automatically add the "£" sign.

 

[SideWinder]

My fault - i had put in the wrong letter as i was using merge.

Thanks again!

 

[asim18]

lol , no problem.