Re: Get rid of scientific format on Excel 2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 11/23/04

Next message: Frank Kabel: "Re: Stop a formula from changing"
Previous message: Frank Kabel: "Re: Can I make a range of cells in a work*** read only ?"
In reply to: Spyros: "Get rid of scientific format on Excel 2003"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 23 Nov 2004 12:48:22 +0100

Hi
try formating the cells as 'Text' before entering the values

--
Regards
Frank Kabel
Frankfurt, Germany
"Spyros" <Spyros@discussions.microsoft.com> schrieb im Newsbeitrag
news:18D10542-D4F9-487A-9C0E-0545A3D9FD89@microsoft.com...
> How can i manage to copy paste phrases such as 1E1 or 13E2 on a new
Excel
> *** and receive the same results and not an exponential form such
as
> 1.00E+01 and 1.30E+03 with values 10 and 1300? I don't believe that
Excel
> can't handdle this problem. Imagine importing similar texts with
macros from
> text files and having your text automatically converted into
scientific
> format.
>

Next message: Frank Kabel: "Re: Stop a formula from changing"
Previous message: Frank Kabel: "Re: Can I make a range of cells in a work*** read only ?"
In reply to: Spyros: "Get rid of scientific format on Excel 2003"
Messages sorted by: [ date ] [ thread ]