Zeros

Alexander · May 14th, 2002, 08:37 AM

What is the format setting to show leading and ending zeros, i.e. how do I show 1.00 for $1.00 in the formula bar and also in the cell? It will say 1.00 in the cell but the formula bar is displaying 1. I need the zeros in both places for a parse and to show up in VB code I am writing. Thanks!!

PDuPre' · May 14th, 2002, 08:50 AM

Can you convert the number to text and then parse it? Only way I know to show 1.00 in the formula bar is if it isn't a number, but text.

Philip

Alexander · May 14th, 2002, 09:02 AM

Philip,
Thanks for the advice, but I'm doing this for a group who cannot convert the files. If this is the only way, we may be out of luck. It is coded in VB then run into a mainframe app, and the process is sticky.
Thanks again!

PDuPre' · May 14th, 2002, 09:27 AM

You could multiply the cell by 100 and then parse the product. That would give you the right two zero's.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 08:37 AM	#1
Alexander New Member Join Date: Apr 2002 Posts: 45	What is the format setting to show leading and ending zeros, i.e. how do I show 1.00 for $1.00 in the formula bar and also in the cell? It will say 1.00 in the cell but the formula bar is displaying 1. I need the zeros in both places for a parse and to show up in VB code I am writing. Thanks!!

May 14th, 2002, 08:50 AM	#2
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	Can you convert the number to text and then parse it? Only way I know to show 1.00 in the formula bar is if it isn't a number, but text. Philip

May 14th, 2002, 09:02 AM	#3
Alexander New Member Join Date: Apr 2002 Posts: 45	Philip, Thanks for the advice, but I'm doing this for a group who cannot convert the files. If this is the only way, we may be out of luck. It is coded in VB then run into a mainframe app, and the process is sticky. Thanks again!

May 14th, 2002, 09:27 AM	#4
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	You could multiply the cell by 100 and then parse the product. That would give you the right two zero's.