Applescript+Excel 2004 - Add digits after the decimal point

Scripting Forums AppleScript | Mac OS X
,
#1

Hello all

Does any one know how to add digits after the decimal point (i.e. make 6 to 6.00 or 6.25) in Excel 2004?

Thanks
Chad

Model: Macbook
AppleScript: 2.0
Browser: Safari 3.0.4
Operating System: Mac OS X (10.4)

#2

Hi,

for example change the number format of a cell (or a range)


tell application "Microsoft Excel"
	tell sheet 1
		tell cell 1 of used range
			set number format to "0.00" -- can be 0,00 in some localizations
		end tell
	end tell
end tell