Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default working with positive and neg numbers

XP/Office 2003

I am merging data fields from Excel 2003 to Pub 2003 using
mail merge functionality

Problem 1
Need to get Positive numbers to move over one space to
left - so align with negative numbers when they have
brackets - this is SA accounting style ie.
500
(500)

Have formatted Excel fields =text(F3,"# ###.00_)") -
which gives correct result in Excel - but does not move
the figure over when merged into Publisher.

Problem 2
Negative numbers still keep the - even when formated as
=text(F3,"(# ###.00)") - even in Excel spreadsheet -
shows up as -(500) - I need to get rid of the minus sign.

Have tried changing settings in regional settings - does
not seem to have helped.

Help plse




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel change a group of positive numbers to negitive numbers Clare Jones Excel Discussion (Misc queries) 3 July 2nd 09 04:25 PM
Excel, change column of negative numbers to positive numbers? Nita New Users to Excel 3 November 27th 07 04:54 AM
Excel 2002 : Convert Positive Numbers to Negative Numbers ? Mr. Low Excel Discussion (Misc queries) 2 November 6th 06 03:30 PM
change 2000 cells (negative numbers) into positive numbers lisbern Excel Worksheet Functions 2 August 16th 06 05:54 PM
convert negative numbers to positive numbers and vice versa bill gras Excel Worksheet Functions 4 December 7th 05 01:39 AM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"