formula bar

mandopolis · Apr 17th, 2002, 03:42 PM

is there any way for the formula bar to contain zeros after the number in a cell after theyve been entered?? (e.g .200) it seems to always revert back to .2 thanx!!

Mark W. · Apr 17th, 2002, 03:59 PM

To be precise... it contains 0.2 which is exactly how the value is stored by Excel. Don't confuse a value's formatting with its internal representation!

[ This Message was edited by: Mark W. on 2002-04-17 15:00 ]

Jack in the UK · Apr 17th, 2002, 04:14 PM

maybe a fix format the cell to X decimal pklaces and force excel to repot as such!

mandopolis · Apr 17th, 2002, 04:19 PM

thaxs 4 the help!

Apr 17th, 2002, 04:14 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	maybe a fix format the cell to X decimal pklaces and force excel to repot as such! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 17th, 2002, 03:42 PM	#1
mandopolis New Member Join Date: Apr 2002 Posts: 9	is there any way for the formula bar to contain zeros after the number in a cell after theyve been entered?? (e.g .200) it seems to always revert back to .2 thanx!!

Apr 17th, 2002, 03:59 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	To be precise... it contains 0.2 which is exactly how the value is stored by Excel. Don't confuse a value's formatting with its internal representation! [ This Message was edited by: Mark W. on 2002-04-17 15:00 ]

Apr 17th, 2002, 04:19 PM	#4
mandopolis New Member Join Date: Apr 2002 Posts: 9	thaxs 4 the help!