Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2020, 07:07 AM
worddombo worddombo is offline Keep format of source value Windows 10 Keep format of source value Office 2016
Novice
Keep format of source value
 
Join Date: Mar 2020
Posts: 3
worddombo is on a distinguished road
Default Keep format of source value


I have two tables, source and destination.
The source table contains formatted values.
The cells of the destination table contains formulas referring to cells in the source table.

Is it possible to keep the format of the source cells ?


I cannot use VBA
Reply With Quote
  #2  
Old 03-25-2020, 02:55 PM
macropod's Avatar
macropod macropod is offline Keep format of source value Windows 7 64bit Keep format of source value Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

How are you referencing the source values?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-25-2020, 11:37 PM
worddombo worddombo is offline Keep format of source value Windows 10 Keep format of source value Office 2016
Novice
Keep format of source value
 
Join Date: Mar 2020
Posts: 3
worddombo is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
How are you referencing the source values?
I bookmarked my source table : reference =
{=SUM(bookmark A1)}
Reply With Quote
  #4  
Old 03-25-2020, 11:43 PM
macropod's Avatar
macropod macropod is offline Keep format of source value Windows 7 64bit Keep format of source value Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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
  #5  
Old 03-26-2020, 04:02 AM
worddombo worddombo is offline Keep format of source value Windows 10 Keep format of source value Office 2016
Novice
Keep format of source value
 
Join Date: Mar 2020
Posts: 3
worddombo is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Thank you for answering
How to refer to a cell in other table ?
I bookmarked that cell, but =sum{bookmark} gives an error.

In my source table there is no numeric picture switch
Reply With Quote
  #6  
Old 03-26-2020, 04:06 AM
macropod's Avatar
macropod macropod is offline Keep format of source value Windows 7 64bit Keep format of source value Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Quote:
Originally Posted by worddombo View Post
How to refer to a cell in other table ?
Via a cross-reference (i.e. Insert|Cross Reference).
Quote:
Originally Posted by worddombo View Post
I bookmarked that cell, but =sum{bookmark} gives an error.
Make sure you haven't included the end-of-cell marker in the bookmark.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep format of source value Retain source format even on combination of multiple documents of different formats G.Anusha Word 12 12-14-2021 03:31 PM
Keep format of source value Can't format REF field (format first letter, use * CHARFORMAT doesn't work) Blaq Word 3 02-19-2019 04:49 PM
Keep format of source value Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match. PhillJ Excel 4 08-22-2017 03:10 AM
Keep format of source value Keeping the source format when extracting data from multiple cells using Vlookup function praboos2001 Excel 6 11-15-2016 04:40 AM
How keep target text format when copying from other source? Kokopelli Excel 8 10-11-2016 11:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft