Toolsoptionsedit tabfixed decimals & set to 2 places
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Jude" wrote:

for speeding up data entry I want to enter the figures without a decimal
point, and have excel make the last two digits decimals. e.g. key in 3925
which will desplay as 39.25. I've done this before but forget how! Its a
custom number format I think
Thanks