Forum Discussion
Solved
F/S presentation
I have the English version of Excel. I have to prepare F/S with a French presentation. Is there any way I can access the Fench presentation, i.e., space instead of a comma and dollar sign at the en...
Just seeing you post now. Three days after you posted it.
From what you describe you want something like this:
Then use a custom format like this:
# ##0_)"$";(# ##0)"$"
I don't know how you want to show negatives. I assumed within parentheses. You can always change that of course.
Riny's fine reply works well for numbers between -999999 and +999999:
If you want to accommodate numbers outside that range, you should set the grouping symbol in your operating system for numbers and currency to a space.
Or use a format such as
[>=1000000]0 000 000 "$";[<=-1000000]-0 000 000 "$";# ##0 "$"
which will work for numbers between -999999999 and +999999999.