Changing a cell

thebigE · Jan 8, 2005

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

Nick Hodge · Jan 8, 2005

Perhaps an example

Do you want 12345 to be 12?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

Don Guillett · Jan 8, 2005

Have a look in HELP index for ROUND