Posted to microsoft.public.excel.misc

Native

Posts: n/a

inputting data with a "+" sign

Is there an option in XL that if I type data into a cell with a + sign
at the beginning the + sign will remain?

For example, in cell A1, if I enter, "+125", the "+" goes away and
leaves the "125". I want the "+" to stay.

For example, if I typed "=125" the "=" stays, but I want to type "+125"
and have the "+" stay.

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
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
I need more general XY point to point plotting than XY scatter in	spazminator	Charts and Charting in Excel	12	December 19th 05 05:00 PM
Inputting Source Data - help please	foredis	Charts and Charting in Excel	1	June 22nd 05 02:36 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
Line Graph Data Recognition	Nat	Charts and Charting in Excel	2	April 30th 05 02:07 PM

All times are GMT +1. The time now is 11:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us