excel

[onlyme!]

Does anyone know after I have put a subtotal function on excel how I get rid of the formulars so I can then sort?

Thanks

 

[b_n_3003]

does highlighting and using the A-Z thingy mess up your formulas

or am I barkign up the wrong tree
x

 

[onlyme!]

the A-Z thingy?! oh dear I am useless!

 

[NettyJ]

explain what you need to do and i will help !

 

[KD]

If you are asking, what I think you're asking, then I would do, copy, edit, paste special, and click the values bit

That way, the formulas disappear, leaving just the answer

Of course, if you weren't thinking what I thought you were thinking...that wont work

 

[b_n_3003]

or you can mail it me and I'll have a look

 

[onlyme!]

thanks guys! I worked it out. I HATE excel! it is so clever and I am not