My testing indicates that the hashes are a result of the number being
longer than the width of the cell. If you change the number format to
restrict the number of digits displayed (something other than
"general"), you shouldn't have a problem.
MED.
Lee Dormon wrote:
> hello all
>
> Does anyone know how I can enter a time value into the spreadsheet,
> the
> syntax in guide says its TIME(hour,minute,second) but if you try and
> input comma separtated values into a cell it just comes up with hashes
>
> in the cell and strips the comma's out when you view it in the top
> window??
>
> Anyone got any ideas? I'm just trying to get a sheet together to do my
>
> timesheet for work. I want to input start and finish time and how long
> I
> had for lunch (yeah right). So if someone's already done this they
> couldn't mail it to me could they?
>
> Cheers for any help
> Lee
-- mailto:Marc.DeVinney@bigfoot.com http://home.att.net/~Marc.DeVinney