how do I convert 1.234,00- to -1,234.00?

  • Thread starter Thread starter wynand
  • Start date Start date
If the minus symbol is appearing as the last character of the cell value then
use this formula.

=IF(TRIM(RIGHT(A1,1))="-","-"&SUBSTITUTE(TRIM(A1),"-",""),TRIM(A1))

Change the cell reference A1 to your desired cell.

If this post helps, Click Yes!
 
Thank you, it works brilliant.
Any ideas on swopping the . and the , around?
 
yes we can swap the dot (.) and comma (,) also but give some example from
where to where do you want to swap it.
 
1.234,00- needs to be -1,234.00 (unlimited numbers 100.00 1,000.00,
10,000.00, 100,000.00 etc)
 
Use this formula

=IF(RIGHT(TRIM(A1),1)="-",("-"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A1),".","/"),",","."),"/",","),"-","")),(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A1),".","/"),",","."),"/",",")))

Change the cell reference to your desired cell.

Or

Select the data column and Press Cntrl+H and replace the comma as dot and in
the same way again replace the dot as comma. That’s it!

If this post helps, Click Yes!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to number conversion with trailing - 2
Custom formatting 3
Format Function Output to numeric (#,###.00) 2
How to convert , comma to . dot in excel to do the following calculation? 2
How to format ListBox columns 3
Changing numbers to text 1
Negative Numbers in Brackets 2
Red cell for negative numbers in Excel 1

Back
Top