OraFAQ Forum: Forms » Format masking of Numbers

Home » Developer & Programmer » Forms » Format masking of Numbers (Forms 6i Orable 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Format masking of Numbers [message #326595]

Thu, 12 June 2008 01:43

adchax
Messages: 32
Registered: June 2008

Member

hello!!
I have a requirement of format masking an item(number) to 999.999999,which is alright by itself,but when i put 0 it becomes .000000,how can i get just 0.
format masking to 000.000000 also doesnt help since then when i put 5 it will give 005.000000.

I need
5 5.000000
0 0.000000
12 12.000000
234 234.000000

Thanks

Report message to a moderator

Re: Format masking of Numbers [message #326601 is a reply to message #326595]

Thu, 12 June 2008 01:53

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Instead of 000"."000000 use 999"."000000

Report message to a moderator

Re: Format masking of Numbers [message #326606 is a reply to message #326601]

Thu, 12 June 2008 02:03

adchax
Messages: 32
Registered: June 2008

Member

Thanks for the reply,but 999.000000 doesnt slove by 0 problem,when i type in 0 it comes as .000000 while i want 0.000000

Report message to a moderator

Re: Format masking of Numbers [message #326607 is a reply to message #326606]

Thu, 12 June 2008 02:04

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Then use 990.000000

Report message to a moderator

Re: Format masking of Numbers [message #326623 is a reply to message #326607]

Thu, 12 June 2008 02:18

adchax
Messages: 32
Registered: June 2008

Member

I dont why its not working ...its giving ###.###### while displaying

Report message to a moderator

Re: Format masking of Numbers [message #326642 is a reply to message #326623]

Thu, 12 June 2008 02:41

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

then drag to expand the size of your item.

Report message to a moderator

Re: Format masking of Numbers [message #326653 is a reply to message #326642]

Thu, 12 June 2008 02:59

adchax
Messages: 32
Registered: June 2008

Member

I fixed that but my intial problem is still not solved.How can I get 0 display instead of .000000

Report message to a moderator

Re: Format masking of Numbers [message #326654 is a reply to message #326653]

Thu, 12 June 2008 03:02

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Mr. adchax please do to an Eye Specialist and examine your eyes I think they are weak. I told you to use 990.00000 in format masking

Report message to a moderator

Re: Format masking of Numbers [message #326668 is a reply to message #326654]

Thu, 12 June 2008 03:55

adchax
Messages: 32
Registered: June 2008

Member

Thank you that did work!
Maybe I do have to get my eyes checked!=)

Report message to a moderator

Previous Topic:	Function Keys in Forms 10G
Next Topic:	running reports thru forms dynamically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 07:01:17 CST 2025