Thread: [Solved] Find & Replace formula for numbers?
View Single Post
 
Old 04-18-2011, 01:43 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Griff,

I just realised your profile says you're using Office 2008 ... which doesn't support macros. The same result could be achieved with a series of Find/Replace operations:
Find = 1
Replace = 0
Find = 2
Replace = 1
Find = 3
Replace = 2
Find = 4
Replace = 3
Find = 5
Replace = 4
Find = 6
Replace = 5
Find = 7
Replace = 6
Find = 8
Replace = 7
Find = 0
Replace = 8
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote