Posted to microsoft.public.excel.worksheet.functions

dindigul

external usenet poster

Posts: 8

Round() problem

I have numbers in cells like 3054.30, 2997.48 etc. that need to be brought
into Word via mailmerge. However, in Word docs the values change to
3054.299999 & 2997.477777 ... I tried using the =ROUND() function it did not
have any effect, then I tried using Paste Special, Values ... still no use.
Why is this happening & what could be done to keep the values as shown?
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Round to .99?	WBTKbeezy	Excel Worksheet Functions	2	November 14th 07 03:23 AM
round down?	Dave F	Excel Discussion (Misc queries)	0	February 15th 07 04:26 PM
@ROUND	steph44haf	Excel Worksheet Functions	4	October 23rd 06 02:06 PM
How do I ROUND() round off decimals of a column dataset?	HÃ¸jrup	Excel Worksheet Functions	2	January 12th 05 10:50 AM
how do I round up?	Martushka	Excel Worksheet Functions	1	January 3rd 05 07:30 PM

All times are GMT +1. The time now is 03:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us