is it only appropriate to insert *different* data into *individual* cells...
 

.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc

is it only appropriate to insert *different* data into *individual* cells...
 

If it is just for display it won't do any harm but I would recommend against
it due to that if you want to do any sort of calculation a good standard
would be to separate numbers from text or else the formulas involved will be
much more complicated and probably a lot slower on a grander scale of data.
So I would avoid it.


--
Regards,

Peo Sjoblom

"showsomeidnow" wrote in message
oups.com...
.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc

is it only appropriate to insert *different* data into *individual*cells...
 

You can do whatever is appropriate.

But if you separate fields into different columns, your life will be much, much
simpler if you ever want to do anything with that data (besides printing).

For instance, if you wanted to add the values in column B, you could use:
=sum(b2:B99)

It would become a very ugly formula if you kept everything in column A.

showsomeidnow wrote:

... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc

--

Dave Peterson

is it only appropriate to insert *different* data into *individual* cells...
 

The second method is NOT recommended. It limits what can be done with the
data.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"showsomeidnow" wrote in message
oups.com...
.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc

is it only appropriate to insert *different* data into *individual
 

It really depends on what you plan to do with the data after you've got it
entered. If you're going to perform any calculations, sorting or lookups on
individual elements of the data, then you'll have a much easier time if each
element is in its own cell. Otherwise, its just a matter of whichever way
you prefer.

HTH,
Elkar


"showsomeidnow" wrote:

.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc

is it only appropriate to insert *different* data into *individual
 

thanks all for the replies as always. i really DO appreciate all the
help you guys (and ladies) give :)