double zeros

[jdupuy3]

i have a column where users will enter seconds. however, if the value i
'00' it shows up at '0'. i made a custom format for the column using
'0#' format, so every other entry works. any ideas?

btw, a later column uses this column for calculations so making it tex
format will not solve the problem.

thanks,
jaso

 

[mudraker]

jdupuy3

try a format of 00 - this an entry of 0 will be dispalyed as 0

 

[jdupuy3]

thank you much. that did the trick :