Special Number Display for Money

Discuss the spreadsheet application

Special Number Display for Money

Postby Stevie » Fri Dec 07, 2007 12:40 pm

Hi,

i would like to have a display that isnt included in the Formulas and i have no idea if its possible to create such a Formular.

I make some examples to explain.

5 should be displayed as 5, not 5,00
0 should be displayed as 0, not 0,00
but
x,1 - x,9 should be displayed as x,10 - x,90

is that possible?

thanks,
greetings
Stevie
Stevie
 
Posts: 10
Joined: Fri Dec 07, 2007 12:31 pm

Re: Special Number Display for Money

Postby acknak » Fri Dec 07, 2007 5:20 pm

There are a couple of ways to go, depending on exactly what you need. You can get what you asked for with a format, but I suspect you will find values where it is not adequate. In that case, there are the other options.
cond_format_options.png
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Special Number Display for Money

Postby Stevie » Mon Dec 10, 2007 5:45 pm

Thanks. That is near i like it. The B formular would be best as i dont want to use it cell specific. but that doesnt work for all numbers. seems such a general formular i would like to have isnt possible.
Stevie
 
Posts: 10
Joined: Fri Dec 07, 2007 12:31 pm

Re: Special Number Display for Money

Postby uros » Tue Dec 11, 2007 8:24 am

Hi Stevie!
Try to use custom number format: 0,##
Is this suitable for your purposes?
Uros
User avatar
uros
Volunteer
 
Posts: 30
Joined: Sun Dec 02, 2007 10:26 pm
Location: Slovenia


Return to Calc

Who is online

Users browsing this forum: dawidek990, robleyd and 36 guests