PC Review


Reply
Thread Tools Rate Thread

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

 
 
Diana
Guest
Posts: n/a
 
      19th Apr 2010
I would to know how to convert an european number in an us number like 174,00
to 174.00

Thanks,

Diana
 
Reply With Quote
 
 
 
 
Eduardo
Guest
Posts: n/a
 
      20th Apr 2010
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:37 PM.