Talk

Advanced search

Excel geeks - I NEEEEEEEEEEEEEEEEEEED you!

(13 Posts)
bloss Mon 21-Sep-09 09:25:12

Message withdrawn

PortAndLemon Mon 21-Sep-09 09:26:11

Which version of Excel - 2003 or 2007 (or something else)?

BecauseImWorthIt Mon 21-Sep-09 09:28:09

<wonders why I click on these threads>

Have you tried setting it to 'general' - I think that has worked for me in the past. If not, just ignore me and wait till someone with more geeky skills than me comes along ....

bloss Mon 21-Sep-09 09:29:27

Message withdrawn

AstronomyDomine Mon 21-Sep-09 09:31:21

type an apostrophe before the first 3 - the cell will then show exactly what's keyed in IYSWIM

VinegarTits Mon 21-Sep-09 09:32:05

If you put and apostrophe before your text it will tell the cell it is text

So try putting '3E1 in the cell

This should work

AstronomyDomine Mon 21-Sep-09 09:32:39

Great minds vinegar smile

VinegarTits Mon 21-Sep-09 09:32:57

sorry x-posts

VinegarTits Mon 21-Sep-09 09:33:10

grin

PortAndLemon Mon 21-Sep-09 09:43:50

Yes, you should have entered the codes as '3E1, '3E2, '3E3 to begin with.

Assuming you now have a long list to change, the quickest and best method is probably to turn on AutoFilter and filter your selection down to one malformed code at a time, correcting to '3E1 (or whatever) in the top instance and then copying that down through the selection.

bloss Mon 21-Sep-09 09:45:06

Message withdrawn

AstronomyDomine Mon 21-Sep-09 09:49:14

or just key in '3E1 then hover over the bottom right hand corner of the cell, hold down the right button and drag down, then release and select "fil series"

AstronomyDomine Mon 21-Sep-09 09:50:45

... meant to add - hover over the bottom right hand corner of the cell until the cursor becomes a little black cross... then right click and drag down...

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now