View Single Post
 
Old 03-19-2019, 01:21 AM
DarrenE DarrenE is offline Windows 10 Office 2016
Banned
 
Join Date: Mar 2019
Posts: 6
DarrenE is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Your description suggests the value in Access is stored as '23 5', not '23.5' and, that without the addition of the picture switch, what you're seeing in the output as '23.5' is actually '23 5' with the space shown as '.'. Clicking on the ¶ symbol on the Ribbon's Home tab to turn off the formatting display would likely confirm that.
Thanks, Paul, but I don't think that is it.

In Access, my field is a currency field and when word opens it pulls only data of 23.5.

When I click the ¶, all I see is at £28.00.¶.
Reply With Quote