I want to enter a figure &excel makes last two digits decimals
=A1/100
Copy down as far as required
"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
|