Hi,
How can I change the value 2.8 to 2,8 using a function?
Regards,
Elio Fernandes
Hi,
How can I change the value 2.8 to 2,8 using a function?
Regards,
Elio Fernandes
Last edited by efernandes67; 05-06-2013 at 10:22 AM.
=substitute(a1, ".", ",")
Last edited by shg; 05-06-2013 at 12:58 AM.
Entia non sunt multiplicanda sine necessitate
@shg: swap comma for comma?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks, TMS, corrected.
@shg: You're welcome. Thanks for the rep.
Thanks to All.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks