How to use frequency function in a particular case

[lecossais]

Hi,

I am a column of formated number cells, when i want to work out th
frequency this ranger, it is all wrong, apparently cos the cell numbe
are formated.

How can i sort this out? ang get right frequency without having t
unformat, 'round' function....

Thanks for your hel

 

[Paul Lautman]

Hi,

I am a column of formated number cells,

Wow, I've never met a column of formatted numbers that could actually post a
message to usenet!

when i want to work out the
frequency this ranger, it is all wrong, apparently cos the cell number
are formated.

You say "apparently cos the cell number are formated." but you haven't given
us any information about this at all. It might be the case, but it is very
likely to be nothing to do with the formatting.

How can i sort this out? ang get right frequency without having to
unformat, 'round' function....

I have no idea, because you haven't actually said anything concrete about
the problem. You haven't given any examples of the actual data, of what you
actually see as a result and what you expect to see.

I guess this is because you are just a column of formated number cells.
Please see if there are any humans around and ask one of them to take a look
at you and maybe post some of your details here.