Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kevin
 
Posts: n/a
Default Convert data type of cells to Text,Number,Date and Time

Converting Data Type could recognize these date format like 2004.12.31,
20041231 and will convert them to the locale format in your computer. It
could convert any data to Text, Number or Date&Time.

The Cell Lens of Locked&Unlocked change the background color of cells
according to their lock/unlock state: the locked cells to gray, the unlocked
cells to blue. Assist has also offered a Quick Lock button to lock the
selected range at once and a Quick Unlock button to unlock immediately. Now
you are very clear about which cells are locked and which cells are unlocked.
Just cancel this Cell Lens, the background color will be restored.

Cell Lens of Data Type render and change the background color of cells
according to their data type: Text to yellow, Number to blue, Date and Time
to green. Just cancel this Cell Lens, the background color will be restored.

If you merge some cells in Excel, just the data of first cell could be
maintained and the data of other cells will be destroyed! Safety Merge of
AddinTools Assist to merge the selected cells and maintain all data. Smart
Unmerge to unmerge the selected cells and the data in every cell will be
split into several cells!

Virtual Screen Rulers helps to align the rows and columns in a big complex
worksheet.
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
is this a question or an advertisement???

--
Regards
Frank Kabel
Frankfurt, Germany

Kevin wrote:
Converting Data Type could recognize these date format like
2004.12.31, 20041231 and will convert them to the locale format in
your computer. It could convert any data to Text, Number or Date&Time.

The Cell Lens of Locked&Unlocked change the background color of cells
according to their lock/unlock state: the locked cells to gray, the
unlocked cells to blue. Assist has also offered a Quick Lock button
to lock the selected range at once and a Quick Unlock button to
unlock immediately. Now you are very clear about which cells are
locked and which cells are unlocked. Just cancel this Cell Lens, the
background color will be restored.

Cell Lens of Data Type render and change the background color of cells
according to their data type: Text to yellow, Number to blue, Date
and Time to green. Just cancel this Cell Lens, the background color
will be restored.

If you merge some cells in Excel, just the data of first cell could be
maintained and the data of other cells will be destroyed! Safety
Merge of AddinTools Assist to merge the selected cells and maintain
all data. Smart Unmerge to unmerge the selected cells and the data
in every cell will be split into several cells!

Virtual Screen Rulers helps to align the rows and columns in a big
complex worksheet.



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
Split combined date time data Mark Ada Excel Discussion (Misc queries) 4 December 1st 04 07:47 PM
Split combined date time data Mark Ada Excel Discussion (Misc queries) 1 December 1st 04 06:55 AM
Split combined date time data Mark Ada Excel Discussion (Misc queries) 1 December 1st 04 04:52 AM
Convert text file to MS_Excel Aqua Flow Excel Discussion (Misc queries) 1 November 30th 04 03:55 AM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 04:24 PM


All times are GMT +1. The time now is 02:34 PM.

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"