I am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits - after I insert those numbers they appear to be calculated/converted in some way - the seventeen digit number is converted into the following: 5.74094E+15

If I double-click within that cell, then the number reverts back to the seventeen digit number I entered. Is there some way I can prevent the Title Number from being calculated/converted?

numbers only goto 15 so you will have to make it TEXT

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits - after I insert those numbers they appear to be calculated/converted in some way - the seventeen digit number is converted into the following: 5.74094E+15

If I double-click within that cell, then the number reverts back to the seventeen digit number I entered. Is there some way I can prevent the Title Number from being calculated/converted?

Either by formatting the cell as TEXT before entering the numbers or by preceding the number with a single quote when entering. The quote will not show, but cause the entry to be treated as text.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Don Guillett" <(E-Mail Removed)> wrote in message news:O2p8%(E-Mail Removed)...
numbers only goto 15 so you will have to make it TEXT

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits - after I insert those numbers they appear to be calculated/converted in some way - the seventeen digit number is converted into the following: 5.74094E+15

If I double-click within that cell, then the number reverts back to the seventeen digit number I entered. Is there some way I can prevent the Title Number from being calculated/converted?

Thanks Don... I'm not quite sure I understand..what do you mean by "make it TEXT?"
"Don Guillett" <(E-Mail Removed)> wrote in message news:O2p8%(E-Mail Removed)...
numbers only goto 15 so you will have to make it TEXT

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits - after I insert those numbers they appear to be calculated/converted in some way - the seventeen digit number is converted into the following: 5.74094E+15

If I double-click within that cell, then the number reverts back to the seventeen digit number I entered. Is there some way I can prevent the Title Number from being calculated/converted?

Thanks - quotation marks around the number solved the problem....for now, this will work fine... thanks
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
Thanks Don... I'm not quite sure I understand..what do you mean by "make it TEXT?"
"Don Guillett" <(E-Mail Removed)> wrote in message news:O2p8%(E-Mail Removed)...
numbers only goto 15 so you will have to make it TEXT

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits - after I insert those numbers they appear to be calculated/converted in some way - the seventeen digit number is converted into the following: 5.74094E+15

If I double-click within that cell, then the number reverts back to the seventeen digit number I entered. Is there some way I can prevent the Title Number from being calculated/converted?

Click on the letter at the top of the column your VIN number is in and then Right-click on that same letter at the top, then > FormatCells > NumberTab > TEXT...............this will format the whole column as text so you don't have to type the quote marks anymore, just the VIN.......

Vaya con Dios,
Chuck, CABGx3


"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
Thanks - quotation marks around the number solved the problem....for now, this will work fine... thanks
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
Thanks Don... I'm not quite sure I understand..what do you mean by "make it TEXT?"
"Don Guillett" <(E-Mail Removed)> wrote in message news:O2p8%(E-Mail Removed)...
numbers only goto 15 so you will have to make it TEXT

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"WhiteHawk" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I am fairly new at using Excel - I am attempting to create a spreadsheet that includes vehicle information.... the Vehicle Title Numbers are seventeen digits - after I insert those numbers they appear to be calculated/converted in some way - the seventeen digit number is converted into the following: 5.74094E+15

If I double-click within that cell, then the number reverts back to the seventeen digit number I entered. Is there some way I can prevent the Title Number from being calculated/converted?

You have your answer, but in the future...
Please post in plain text instead of HTML, RTF or whatever
option you chose. Some of the repliers also posted in HTML
because of the original post. Would suggest everyone choose
the option however you see it as Always post in Plain Text.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"WhiteHawk" <(E-Mail Removed)> wrote ...
I am fairly new at using Excel - I am attempting to create a spreadsheet that includes

Also, there's a setting in O.E.:
<Tools> <Options> <Send> tab,

*Uncheck*
"Reply to messages in the format in which they were sent".
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David McRitchie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You have your answer, but in the future...
> Please post in plain text instead of HTML, RTF or whatever
> option you chose. Some of the repliers also posted in HTML
> because of the original post. Would suggest everyone choose
> the option however you see it as Always post in Plain Text.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "WhiteHawk" <(E-Mail Removed)> wrote ...
> I am fairly new at using Excel - I am attempting to create a spreadsheet
that includes
>
>