Thread: [Solved] Keep format of source value
View Single Post
 
Old 03-25-2020, 11:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
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
To retain the formatting of the value of a particular cell, you need to either:
• bookmark that value and reference that bookmark, not the table bookmark; or
• apply the same numeric picture switch to your formula field as the cell you're referencing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote