how to convert an european number in an us number like 174,00 to 1

's Computer Specifications

I would to know how to convert an european number in an us number like 174,00
to 174.00

Thanks,

Diana

's Computer Specifications

Hi Diana,
in another column enter

=SUBSTITUTE(B4,",",".",1)

"Diana" wrote:

> I would to know how to convert an european number in an us number like 174,00
> to 174.00
>
> Thanks,
>
> Diana

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting European number formats	Sarah H.	Microsoft Excel Programming	7	6th Sep 2010 12:18 AM
Excel 2003, European number format	Loulou	Microsoft Excel Misc	2	21st Aug 2008 04:03 PM
number of days between two dates in european format	manan	Microsoft Excel Discussion	3	22nd May 2006 11:38 AM
convert text-format number to number in excel 2000%3f	=?Utf-8?B?TGFycnk=?=	Microsoft Excel Misc	1	29th Jul 2005 08:18 PM
command excel macros to convert a list 5 number number combinati.	=?Utf-8?B?ZXhjYWxpYnVy?=	Microsoft Access Macros	0	7th Dec 2004 04:55 AM