change the code back to its original form after exporting from accounting system

**mingali** · 09-03-2009, 05:37 AM

Hi,

In the accounting system, the codes are as follows:

30E01
30E02
30E03

However, after exporting it to excel, the format change and become:

3.00E+02
3.00E+03
3.00E+04

how to return the codes back to its original format without manually rekey those codes?

Thanks

**martindwilson** · 09-03-2009, 06:20 AM

when you import it ,in the wizard change the field to text

**martindwilson** · 09-03-2009, 09:59 AM

or you could convert bach with
=IF(--LEFT(TEXT(A1,"0.00E+00"),2)<10,LEFT(TEXT(A1,"0.00E+00"),2)*10,LEFT(TEXT(A1,"0.00E+00"),2))&"E"&RIGHT(TEXT(A1,"0.00E+00"),2)

change the code back to its original form after exporting from accounting system

LinkBack

Thread Tools

Rate This Thread

Display

change the code back to its original form after exporting from accounting system

Re: change the code back to its original form after exporting from accounting system

Re: change the code back to its original form after exporting from accounting system

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions