Keep format of source value

		Microsoft Office Forums > Microsoft Word > Word
Keep format of source value

FAQ

Thread Tools

Display Modes

03-26-2020, 04:02 AM

worddombo

Windows 10 Keep format of source value

Office 2016

Novice

Join Date: Mar 2020

Posts: 4

Quote:

Originally Posted by macropod

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Retain source format even on combination of multiple documents of different formats	G.Anusha	Word	12	12-14-2021 03:31 PM
Can't format REF field (format first letter, use * CHARFORMAT doesn't work)	Blaq	Word	3	02-19-2019 04:49 PM
Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match.	PhillJ	Excel	4	08-22-2017 03:10 AM
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