LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 151
Default Converting/inserting values, without changing the other contents.

Hi all
this is what i requi
the overdue is INR 250k (SGD 7,543), out of which for INR 125k (SGD 3,771)
payment is processed, for INR 30k (SGD 905) bills resubmitted for queries,
for INR 25k (SGD 754) supporting were resubmitted, for INR 45k (SGD 1,358)
payment will be made in 1week of next month.
the above comments will be in m5 without the sgd value, i need help to
converrt those values and show as above in n5, after multiplying the
converting factor at b2

thank you


 
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
Inserting rows while keeping cell contents the same JDNETTC Excel Discussion (Misc queries) 4 January 30th 08 11:34 PM
Converting NOW contents to TIME Phrank Excel Worksheet Functions 3 September 2nd 07 03:28 PM
Inserting rows without changing formula values Hook''em 2006 Excel Worksheet Functions 5 December 27th 06 09:45 PM
Converting cell contents to a formula Neil Excel Worksheet Functions 4 July 27th 05 06:27 AM
Inserting Cell Contents into a header Darin Kramer Excel Programming 3 December 13th 04 02:27 PM


All times are GMT +1. The time now is 09:29 PM.

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

About Us

"It's about Microsoft Excel"