Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-18-2023, 08:16 PM
newcomer@flounder.com's Avatar
newcomer@flounder.com newcomer@flounder.com is offline Syntax Error in computed field Windows 11 Syntax Error in computed field Office 2021
Novice
Syntax Error in computed field
 
Join Date: Sep 2023
Location: Pittsburgh, PA, USA
Posts: 3
newcomer@flounder.com is on a distinguished road
Default Syntax Error in computed field

Following the instructions that I found, I wanted to get an approximate word count (rounded to 100), so I put in the suggested formula,



Code:
Approximately {=ROUND({NUMWORDS},-2) \# ,0,} words
but when I toggle the field codes, I get

Code:
  Approximately!Syntax Error, {words
I am using Office 365.

Various attempts including the very detailed document on expressions in Word (Word Field Maths V1_5.doc) did not clarify this problem.


So I went back and just replaced the field. I selected the format #,##0, as a number, and got
Code:
NUMWORDS  \# "#,##0" \* Arabic  \* MERGEFORMAT
and got
Code:
Approximately 3107 words

instead of the expected
Code:
Approximately 3,107 words

Last edited by newcomer@flounder.com; 09-18-2023 at 08:33 PM. Reason: Did not get comma on second attempt, so added that
Reply With Quote
 

Tags
fields, fields word functions



Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax Error in computed field What is the syntax error with .Text "^p" ? Tom1956 Word VBA 5 09-21-2020 09:24 PM
Syntax error on formula that works in spreadsheet Mxthomp Excel Programming 1 11-02-2016 06:49 PM
Mail Merge Field - Trying to divide time however receiving !Syntax, ; Jake0254 Mail Merge 1 09-24-2014 12:58 AM
Error handling in formula - suppress 'Syntax Error' Cosmo Word 7 02-24-2014 07:08 AM
Using multiple formulas in one (IF, AND and SUM) gives syntax error markdeniet Word 1 02-05-2014 05:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 PM.


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