| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Like a note but it's not-What is it?
Hi,
I have cell that does not have a note in it but has something that looks like a note pop up. It says (mm/dd/yy, Initials). There is absolutely no code associated with the workbook. It is almost like a input mask not or something. I need to be able to change the "note" to (dd/mm/yy, Initials). I would greatly appreciate any help. -- Thanks! Gary S |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like a note but it's not-What is it?
On Jul 31, 1:45*pm, Gary S wrote:
Hi, I have cell that does not have a note in it but has something that looks like a note pop up. *It says (mm/dd/yy, Initials). * There is absolutely no code associated with the workbook. It is almost like a input mask not or something. * I need to be able to change the "note" to (dd/mm/yy, Initials). * I would greatly appreciate any help. -- Thanks! Gary S Look at Data, validation, it sounds like someone has defined an input mask and a comment there |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like a note but it's not-What is it?
Hi,
Check Data validation, sounds like the Input message. Cheers Andy Gary S wrote: Hi, I have cell that does not have a note in it but has something that looks like a note pop up. It says (mm/dd/yy, Initials). There is absolutely no code associated with the workbook. It is almost like a input mask not or something. I need to be able to change the "note" to (dd/mm/yy, Initials). I would greatly appreciate any help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like a note but it's not-What is it?
does it have a triangle in the upper right corner of the cell? if so, it's
comment. right click on the cell and delete it. -- Gary Keramidas Excel 2003 "Gary S" wrote in message ... Hi, I have cell that does not have a note in it but has something that looks like a note pop up. It says (mm/dd/yy, Initials). There is absolutely no code associated with the workbook. It is almost like a input mask not or something. I need to be able to change the "note" to (dd/mm/yy, Initials). I would greatly appreciate any help. -- Thanks! Gary S |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like a note but it's not-What is it?
Mega thanks to Andy and Regmigrant!
That was it, problem soled! -- Thanks! Gary S "Andy Pope" wrote: Hi, Check Data validation, sounds like the Input message. Cheers Andy Gary S wrote: Hi, I have cell that does not have a note in it but has something that looks like a note pop up. It says (mm/dd/yy, Initials). There is absolutely no code associated with the workbook. It is almost like a input mask not or something. I need to be able to change the "note" to (dd/mm/yy, Initials). I would greatly appreciate any help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation note to comment note | Excel Discussion (Misc queries) | |||
| A note of appreciation | New Users to Excel | |||
| Note in Cell | New Users to Excel | |||
| a note on a workbook | Excel Worksheet Functions | |||
| How can I return a thank you note | Excel Worksheet Functions | |||
![Gary S[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
