I have a product number 00E1 - Excel always wants to display it as 0.00E+00.
I can get it to display as I want if I format the cell as text. However, I
then need to save it as a csv file and then it changes back to 0.00E+00. Any
suggestions how to keep the format as text rather than converting it back to
a number?
--
maryj

Precede the 00E1 with a single quote (apostrophe). This will not display nor
print.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"maryj" wrote in message
...
I have a product number 00E1 - Excel always wants to display it as
0.00E+00.
I can get it to display as I want if I format the cell as text. However, I
then need to save it as a csv file and then it changes back to 0.00E+00.
Any
suggestions how to keep the format as text rather than converting it back
to
a number?
--
maryj

Thanks!
The only problem is that there can be hundreds and possibly thousands of
rows in the file. Not all have this exact same letter/number combination. Is
there an easy way to add the preceding apostrophe to all values in that
column?
--
maryj


"Bernard Liengme" wrote:

Precede the 00E1 with a single quote (apostrophe). This will not display nor
print.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"maryj" wrote in message
...
I have a product number 00E1 - Excel always wants to display it as
0.00E+00.
I can get it to display as I want if I format the cell as text. However, I
then need to save it as a csv file and then it changes back to 0.00E+00.
Any
suggestions how to keep the format as text rather than converting it back
to
a number?
--
maryj

Tried typing in the apostrophe but it still changed to 0.00E00 when saved as
csv. Any other suggestions??
--
maryj


"Bernard Liengme" wrote:

Precede the 00E1 with a single quote (apostrophe). This will not display nor
print.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"maryj" wrote in message
...
I have a product number 00E1 - Excel always wants to display it as
0.00E+00.
I can get it to display as I want if I format the cell as text. However, I
then need to save it as a csv file and then it changes back to 0.00E+00.
Any
suggestions how to keep the format as text rather than converting it back
to
a number?
--
maryj

Where will the *.csv file be applied?

I find that using either method....format or apostrophe............will produce
00E1 on saving as *.csv but when re-opening the *.csv file with Excel the 00E1
reverts to 0.00E+00

If the *.csv file is opened using NotePad or any othe text application the 00E1
is preserved.

In answer to the question below..............I can provide a macro to add an
apostrophe to every cell in a range if you wish.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 06:01:02 -0700, harriettbird
wrote:

Thanks!
The only problem is that there can be hundreds and possibly thousands of
rows in the file. Not all have this exact same letter/number combination. Is
there an easy way to add the preceding apostrophe to all values in that
column?

Thanks Gord - you were right - it did show appropriately in Notepad. It
eventually went into another application. For some reason last month it
bombed at those values but this time it seemed to work.
--
harriettbird


"Gord Dibben" wrote:

Where will the *.csv file be applied?

I find that using either method....format or apostrophe............will produce
00E1 on saving as *.csv but when re-opening the *.csv file with Excel the 00E1
reverts to 0.00E+00

If the *.csv file is opened using NotePad or any othe text application the 00E1
is preserved.

In answer to the question below..............I can provide a macro to add an
apostrophe to every cell in a range if you wish.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 06:01:02 -0700, harriettbird
wrote:

Thanks!
The only problem is that there can be hundreds and possibly thousands of
rows in the file. Not all have this exact same letter/number combination. Is
there an easy way to add the preceding apostrophe to all values in that
column?