Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BitsofColour
 
Posts: n/a
Default create default cell value

Is there a way to specify a cell to contain a default value?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Not really, but if you're using a formula, you could look for the "emptyness" of
that cell and use that:

=if(a1="","whatyourdefaultwouldbe",A1)



BitsofColour wrote:

Is there a way to specify a cell to contain a default value?


--

Dave Peterson
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
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Create a pick list to use to go to a text cell in Excel Pegita Excel Worksheet Functions 1 June 23rd 05 07:24 PM
Default cell alignment Stuart Excel Discussion (Misc queries) 0 April 17th 05 09:41 AM
Set default in auto fill options, I always want to copy cell, som. OSHAman Excel Discussion (Misc queries) 2 March 25th 05 11:22 PM
how do i create a list from a cell? AT New Users to Excel 2 December 15th 04 07:40 PM


All times are GMT +1. The time now is 12:24 AM.

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

About Us

"It's about Microsoft Excel"