Prev: Excel 2003 Working Day Formula
Next: Screen view
From: Aqeel Kohari on 8 Feb 2010 01:04
I have a large file Excel, which comtains lot of sheets.
Today, the full numbers in the file been changed from none Euro Currency
sign.

Below is an example :
Before : 126310
Now : €126,310.00

Please advise how can i fix for all ?
If i do it manually, it will cost me full day

From: OssieMac on 8 Feb 2010 01:14
Select the columns containing the Euro format then select
Format -> Cells -> Number tab and set the format to Number and set the
decimal places to zero in the dialog box.


--
Regards,

OssieMac


"Aqeel Kohari" wrote:

> I have a large file Excel, which comtains lot of sheets.
> Today, the full numbers in the file been changed from none Euro Currency
> sign.
>
> Below is an example :
> Before : 126310
> Now : €126,310.00
>
> Please advise how can i fix for all ?
> If i do it manually, it will cost me full day
>
 | 
Pages: 1
Prev: Excel 2003 Working Day Formula
Next: Screen view