Trouble with zero's

joe77 · Mar 15th, 2002, 06:36 PM

Is there a simple way to either record a macro, or do a bit of VB programming that would take a cell's contents and add a leading zero to it? Example, value is :20, but I need it to be 0:20. It has to do with the way the sheet was setup, and since there is a formula that relies on this value (it is a time value), it just gives me the value error if I don't add the zeroes. Thanks in advance for any help.

Anne Troy · Mar 15th, 2002, 07:16 PM

Better if we know the formula, Joe. Otherwise, if :20 is 20 minutes, why don't you try this format on the cells:

h:mm

joe77 · Mar 19th, 2002, 09:40 PM

Actually, I did a little poking around, and found some hidden columns I did not notice before. I was able to cobble together the information I needed. I thank you for your reply though.

Mar 15th, 2002, 07:16 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Better if we know the formula, Joe. Otherwise, if :20 is 20 minutes, why don't you try this format on the cells: h:mm __________________ ~Anne Troy

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

Mar 15th, 2002, 06:36 PM	#1
joe77 New Member Join Date: Mar 2002 Posts: 9	Is there a simple way to either record a macro, or do a bit of VB programming that would take a cell's contents and add a leading zero to it? Example, value is :20, but I need it to be 0:20. It has to do with the way the sheet was setup, and since there is a formula that relies on this value (it is a time value), it just gives me the value error if I don't add the zeroes. Thanks in advance for any help.

Mar 19th, 2002, 09:40 PM	#3
joe77 New Member Join Date: Mar 2002 Posts: 9	Actually, I did a little poking around, and found some hidden columns I did not notice before. I was able to cobble together the information I needed. I thank you for your reply though.