View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Problem in all numbers - switched mistakenly from none to Euro sig

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