ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Column A in Excel (https://www.excelbanter.com/charts-charting-excel/20744-column-excel.html)

Joanne Willis
Column A in Excel
 
How do I record part numbers in Column A of Excel without them reverting to
date format?

JE McGimpsey
In article ,
"Joanne Willis" <Joanne wrote:

How do I record part numbers in Column A of Excel without them reverting to
date format?

Preformat the cells as Text, or precede entries that look like dates to
the parser with an apostrophe (').


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

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