Formatinc cents in Excel

[PH]

Hi guys, I hope you can help me with this one.



In a cell I may have a value like 0.05 or 0.16 or 1.16 (these are dollar
amounts)



I will like to format these numbers following this criterion:



If its by instance 0.05 ---> 5 cents

If its 0.16 ---> 16 cents

If its 1.14 ---> I willl leave 1.14





Thanks

 

[Niek Otten]

=TEXT(A1,IF(A1<1,"0 ""cents""","0.00"))

Carefully count the quotes or copy and paste

--
Kind regards,

Niek Otten

Hi guys, I hope you can help me with this one.



In a cell I may have a value like 0.05 or 0.16 or 1.16 (these are dollar amounts)



I will like to format these numbers following this criterion:



If its by instance 0.05 -à 5 cents

If its 0.16 -à 16 cents

If its 1.14 -à I willl leave 1.14





Thanks

 

[PH]

Niek, thanks for your reply.

The example is not returning what I need.



In this particular case;




0.50

1 cents



Return 1 cents instead of 50 cents



What do you think may be wrong?



Thanks

Regards





_____

From: Niek Otten [mailto:[email protected]]
Posted At: Thursday, March 09, 2006 2:02 PM
Posted To: microsoft.public.excel
Conversation: Formatinc cents in Excel
Subject: Re: Formatinc cents in Excel


=TEXT(A1,IF(A1<1,"0 ""cents""","0.00"))



Carefully count the quotes or copy and paste


--
Kind regards,



Niek Otten


Hi guys, I hope you can help me with this one.



In a cell I may have a value like 0.05 or 0.16 or 1.16 (these are dollar
amounts)



I will like to format these numbers following this criterion:



If its by instance 0.05 ---> 5 cents

If its 0.16 ---> 16 cents

If its 1.14 ---> I willl leave 1.14





Thanks

 

[Niek Otten]

Sorry!

=IF(A1<1,TEXT(A1*100,"0 ""cents"""),TEXT(A1,"0.00"))

--
Kind regards,

Niek Otten

Niek, thanks for your reply.

The example is not returning what I need.



In this particular case;



0.50
1 cents




Return 1 cents instead of 50 cents



What do you think may be wrong?



Thanks

Regards






------------------------------------------------------------------------------

From: Niek Otten [mailto:[email protected]]
Posted At: Thursday, March 09, 2006 2:02 PM
Posted To: microsoft.public.excel
Conversation: Formatinc cents in Excel
Subject: Re: Formatinc cents in Excel


=TEXT(A1,IF(A1<1,"0 ""cents""","0.00"))



Carefully count the quotes or copy and paste


--
Kind regards,



Niek Otten


Hi guys, I hope you can help me with this one.



In a cell I may have a value like 0.05 or 0.16 or 1.16 (these are dollar amounts)



I will like to format these numbers following this criterion:



If its by instance 0.05 -à 5 cents

If its 0.16 -à 16 cents

If its 1.14 -à I willl leave 1.14





Thanks

 

[PH]

You are the man!



Thank you very much Niek!



_____

From: Niek Otten [mailto:[email protected]]
Posted At: Thursday, March 09, 2006 2:32 PM
Posted To: microsoft.public.excel
Conversation: Formatinc cents in Excel
Subject: Re: Formatinc cents in Excel


Sorry!



=IF(A1<1,TEXT(A1*100,"0 ""cents"""),TEXT(A1,"0.00"))


--
Kind regards,



Niek Otten


Niek, thanks for your reply.

The example is not returning what I need.



In this particular case;




0.50

1 cents



Return 1 cents instead of 50 cents



What do you think may be wrong?



Thanks

Regards






_____


From: Niek Otten [mailto:[email protected]]
Posted At: Thursday, March 09, 2006 2:02 PM
Posted To: microsoft.public.excel
Conversation: Formatinc cents in Excel
Subject: Re: Formatinc cents in Excel


=TEXT(A1,IF(A1<1,"0 ""cents""","0.00"))



Carefully count the quotes or copy and paste


--
Kind regards,



Niek Otten


Hi guys, I hope you can help me with this one.



In a cell I may have a value like 0.05 or 0.16 or 1.16 (these are dollar
amounts)



I will like to format these numbers following this criterion:



If its by instance 0.05 ---> 5 cents

If its 0.16 ---> 16 cents

If its 1.14 ---> I willl leave 1.14





Thanks