Hi all,
I have a spreadsheet of prices such as £25.00 but these show as £23,50. I am unable to change to the dot from comma even when I change the format to accounting or currency. Any help appreciated thanks.
Hi all,
I have a spreadsheet of prices such as £25.00 but these show as £23,50. I am unable to change to the dot from comma even when I change the format to accounting or currency. Any help appreciated thanks.
have you tried the find and replace all?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Please try this function
=SUBSTITUTE(SUBSTITUTE(A1,".",""),",",".")+0
Please click 'Add reputation', if my answer helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks