how do i undo my conversion to text?

T

trish

i saw the messages form april/06 re this topic. does anyone else have any
ideas?( i had not saved the data before converting it and also did ssome
editing theefore undo does not work :( apprecaite your help!
onenote 2003 SP2
 
E

Erik Sojka (MVP)

If it's too late to do Undo, your only choices are to edit/correct the
converted text (i.e. make the best out of the situation) or restore an old
backup from File | Open Backup. Hopefully your backup settings would allow
you to find an older pre-conversion backup of the file in question.
 
O

OC

I've used the COPY - PASTE SPECIAL - MULTIPLY option with success in the
past. I don't know what you're working with so I'm not sure if it will help
you but what you do is this. Place a 1 in a blank cell you know has the
general format assigned. Then you copy that cell with the 1 in it. Then
highlight the cells that are now text, right click and choose paste special.
Choose multiply from the Operation section, down on the right hand side in
the middle of the box. This should convert your text back to a number.
Hope it helps...
OC
 

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

I have lost 6 months work, how can i get my file back 1
How do I set focus (and select text) on a text box on a modeless userform? 0
unconvert text 3
HOW DO I TURN MY UNDO REDO FUNCTIONS BACK ON IN MICROSOFT EXCEL 1
How do I Undo a Page-Break in excel 1
Outlook 2016 Add-in that creates an html signature doesn't embed images(logos). How can I do this ? 0
How do I install Microsoft Equation 3.0 back to Office 365? 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top