![]() |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 11:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com