Any ideas for a more customized data entry?

[FBB]

I need to be able to enter data in one of two ways, but have it result in the
same value. For example,

I need to be able to enter the decimal number '11.22' as
11.22 or <-- I know how to do that :-)
1122 <-- and that :-)
but in the end, the number needs to be understood as '11.22'

So basically my problem is that I'm either stuck with one data entry method,
or another, but I can't seem to find a way to use both in the same cell.
I've toyed with the data validation feature, but I haven't found a way to
make it do what I want.

[Bill Kuunders]

go to

tools<>options<>edit<>

tick
fixed decimal places and select 2 decimals

--
Greetings from New Zealand
Bill K

"FBB" <[email protected]> wrote in message
news:[email protected]...
>I need to be able to enter data in one of two ways, but have it result in
>the
> same value. For example,
>
> I need to be able to enter the decimal number '11.22' as
> 11.22 or <-- I know how to do that :-)
> 1122 <-- and that :-)
> but in the end, the number needs to be understood as '11.22'
>
> So basically my problem is that I'm either stuck with one data entry
> method,
> or another, but I can't seem to find a way to use both in the same cell.
> I've toyed with the data validation feature, but I haven't found a way to
> make it do what I want.
>

[FBB]

Sure! but that's too easy! :-)

thank you so much!!

"Bill Kuunders" wrote:

> go to
>
> tools<>options<>edit<>
>
> tick
> fixed decimal places and select 2 decimals
>
> --
> Greetings from New Zealand
> Bill K
>
> "FBB" <[email protected]> wrote in message
> news:[email protected]...
> >I need to be able to enter data in one of two ways, but have it result in
> >the
> > same value. For example,
> >
> > I need to be able to enter the decimal number '11.22' as
> > 11.22 or <-- I know how to do that :-)
> > 1122 <-- and that :-)
> > but in the end, the number needs to be understood as '11.22'
> >
> > So basically my problem is that I'm either stuck with one data entry
> > method,
> > or another, but I can't seem to find a way to use both in the same cell.
> > I've toyed with the data validation feature, but I haven't found a way to
> > make it do what I want.
> >
>
>
>