Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 05:26 PM
Norm Genest
 
Posts: n/a
Default How to Insert function right on text values e.g. 0180001640

The new field on the spreadsheet reflects the inserted formula and not the
resulting value. During the insert process however, the expected output
appears properly in the Function Arguments window.

  #2   Report Post  
Old May 18th 05, 05:51 PM
Peo Sjoblom
 
Posts: n/a
Default

Make sure the cell that holds the formula is not formatted as text, you can
try this, select the cell, format as general, press F2 and enter


Regards,

Peo Sjoblom

"Norm Genest" wrote:

The new field on the spreadsheet reflects the inserted formula and not the
resulting value. During the insert process however, the expected output
appears properly in the Function Arguments window.



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
Insert characters in a text string jamae918 Excel Worksheet Functions 1 March 28th 05 10:04 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
How do I insert a row when using an if function BP Excel Worksheet Functions 1 December 27th 04 05:15 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Variable values in Index function mlkpied Excel Worksheet Functions 6 December 6th 04 11:38 PM


All times are GMT +1. The time now is 03:19 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017