Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Stanek
 
Posts: n/a
Default Data Input

I need a quick solution to a data input issue. I have a sales forecast where
the "end user" had to type sales projections for the rest of the year. They
input the raw number, instead of the formula with the number. Example 5
instead of =5. Since I am using hyperion essbase it will remove all of the
forecast work unless it recogonizes the cell as a formula.

Question? Does anyone know of a quick way of turning 5 into =5 in the
cells?

Thanks
 
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
Variable input to populate data fields csinvestor Excel Discussion (Misc queries) 3 September 9th 05 09:00 AM
Need to input data in excel that will print to pre printed sheets Q Setting up and Configuration of Excel 2 June 17th 05 09:06 PM
input text at front of field that contains data Steve M Excel Discussion (Misc queries) 3 May 16th 05 12:28 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 02:36 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"