Number and date
 

Hi !! i have a textbox in a form where i write a number
all works allright, but when i save this cell to a sheet
the number become a date, i have en the sheet write
that the format of this cell is a number.

What do i wrong here?

Best regards alvin

Number and date
 

Hi
how do you write this number to you cell (post the relevant part of your
code)

--
Regards
Frank Kabel
Frankfurt, Germany

Alvin Hansen wrote:
Hi !! i have a textbox in a form where i write a number
all works allright, but when i save this cell to a sheet
the number become a date, i have en the sheet write
that the format of this cell is a number.

What do i wrong here?

Best regards alvin

Number and date
 

Alvin,

Is the cell formatted as a date? Or are you entering fractions?

Both of these could make Excel read the value as a date.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alvin Hansen" wrote in message
...
Hi !! i have a textbox in a form where i write a number
all works allright, but when i save this cell to a sheet
the number become a date, i have en the sheet write
that the format of this cell is a number.

What do i wrong here?

Best regards alvin

Number and date
 

Well i have change the cell to antoher cell
and now it's working

Best regrads
alvin


"Frank Kabel" skrev:

Hi
how do you write this number to you cell (post the relevant part of your
code)

--
Regards
Frank Kabel
Frankfurt, Germany

Alvin Hansen wrote:
Hi !! i have a textbox in a form where i write a number
all works allright, but when i save this cell to a sheet
the number become a date, i have en the sheet write
that the format of this cell is a number.

What do i wrong here?

Best regards alvin

Number and date
 

Sounds like it was formatted as a date.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alvin Hansen" wrote in message
...
Well i have change the cell to antoher cell
and now it's working

Best regrads
alvin


"Frank Kabel" skrev:

Hi
how do you write this number to you cell (post the relevant part of your
code)

--
Regards
Frank Kabel
Frankfurt, Germany

Alvin Hansen wrote:
Hi !! i have a textbox in a form where i write a number
all works allright, but when i save this cell to a sheet
the number become a date, i have en the sheet write
that the format of this cell is a number.

What do i wrong here?

Best regards alvin