Changing a cell

T

thebigE

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

Nick Hodge

Perhaps an example

Do you want 12345 to be 12?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Style Heading 2 5
Word- Find and Replace 1
Delete all data after a symbol in a field 0
How to insert Certificated digital signature in Word for Mac 0
Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Multiple formats in one cell 1
Adding recognised Zeros 5

Top