ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help on data style issues.... (https://www.excelbanter.com/excel-worksheet-functions/171899-help-data-style-issues.html)

golfdunwoody

Help on data style issues....
 
Help please; when I change a data style in one cell, it changes the data type
in all cells. As an example if I change one cell to a date, all the cells
convert to a date format.

Q. How do I change on cell to a different style without changing all the
cell in the worksheet to this style?

--
Thank you!

Gord Dibben

Help on data style issues....
 
Select the cell and FormatCellsNumberDate....choose a format.


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:30:03 -0800, golfdunwoody
wrote:

Help please; when I change a data style in one cell, it changes the data type
in all cells. As an example if I change one cell to a date, all the cells
convert to a date format.

Q. How do I change on cell to a different style without changing all the
cell in the worksheet to this style?



golfdunwoody

Help on data style issues....
 
Gord Dibben,

Thank you!


--
Thank you!


"Gord Dibben" wrote:

Select the cell and FormatCellsNumberDate....choose a format.


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:30:03 -0800, golfdunwoody
wrote:

Help please; when I change a data style in one cell, it changes the data type
in all cells. As an example if I change one cell to a date, all the cells
convert to a date format.

Q. How do I change on cell to a different style without changing all the
cell in the worksheet to this style?





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com