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

SideWinder · 28 Sep 2009 at 00:01

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 · 28 Sep 2009 at 00:26

Styles > Normal.

SideWinder · 28 Sep 2009 at 00:31

asim18 said:
Styles > Normal.

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

asim18 · 28 Sep 2009 at 00:36

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 · 28 Sep 2009 at 00:41

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 · 28 Sep 2009 at 00:51

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 · 28 Sep 2009 at 01:06

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

Thanks again!

asim18 · 28 Sep 2009 at 01:08

lol

, no problem.