Posted to microsoft.public.excel.misc

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

Entering Almost Nothing

If I want to enter a null character in a cell, I:

1. enter ="" in A1
2. copy A1
3. select A2
4. paste/special/value

A2 will now contain the null (ISBLANK(A2) will display FALSE)

Is there any way I can accomplish this without using this cumbersome process?
--
Gary''s Student - gsnu200901

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
Entering HH:MM	Carole O	Excel Discussion (Misc queries)	9	October 5th 09 09:56 PM
Entering Data	need help	Excel Discussion (Misc queries)	1	February 13th 08 07:04 PM
Entering Time	Dave	Excel Discussion (Misc queries)	6	February 9th 08 02:14 AM
entering a 0 before a number	christielee	Excel Discussion (Misc queries)	4	April 17th 07 09:22 PM
102. not entering the same as 102.00	Stacy	Excel Discussion (Misc queries)	8	December 2nd 05 06:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us