format grid cell

On my grid i'm defining what data to show, colors, etc. Now, I have one
column were i need to show the time instead of seconds, I have the code to
convert time to seconds, but how can I get that into my grid?

i have
sub GridFormat()

I hit post by accident

sub GridFormat()
with datagrid1
.HeaderText = "appearance time"
.MappingName = "time" ' i need this to be my variable for the conversion
end with

if i put my variable for the conversion in the mappingname section it does
not display.. how can i get my varable to work in the mapping name section?


here is what i have

"Mike" wrote:

> On my grid i'm defining what data to show, colors, etc. Now, I have one
> column were i need to show the time instead of seconds, I have the code to
> convert time to seconds, but how can I get that into my grid?
>
> i have
> sub GridFormat()
>
>
>