Perhaps an example

Do you want 12345 to be 12?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"thebigE" wrote in message
...
Can you actually change the number in Excel from a 5 digit to a 2 digit
number? Not just what is displayed