exponential notation

[Guest]

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?

 

[Bernard Liengme]

Precede the 00E1 with a single quote (apostrophe). This will not display nor
print.
best wishes

 

[Guest]

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?

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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.